I want to stop using diapers for my three year old in the night, but afraid that it would affect his sleep. Should I wait?

I think you should take the leap of faith if not it will never happen. If you're worried of wetting the bed you could line it with a rubber mat and an incontinence sheet. Just do it and have faith in your kid!