I wear diapers to bed every night and have for at least 50 years except on occasions where I am some place I can not and I still wake up if I need to pee.
I find I sleep better when wearing diapers to bed. I wake up wet and go back to sleep. still after all the years wearing to bed I am not wetting in my sleep how ever I
would be ok if I did. I have tried hypnosis tapes, drinking and not drinking but I still wake up to wet, I use either top rated disposable diapers with doubler or cloth diapers with plastic pants or rubber pants, and washable under pads as I don't find wet diapers uncomfortable but I hate leaks.
Good luck what ever you decide.