My DH can sleep through anything - he simply does not hear when V wakes up. But he has offered that he will do the nights when V goes to his own room. So basically V will wake me up and I will kick DH out of bed to go see what's up. Or maybe I'll just invest in good earplugs and tape baby monitor to DH's ear..
As for pregnancy, no I didn't like being pregnant and would not mind if I didn't have to do it again. Even though I had the easiest pregnancy possible and I did enjoy the horrified "you're still here??" comments from gym and work 
It's just the worrying that I dont manage well, especially if you are like me and read about everything that could possibly go wrong. Honestly, that's a really, really stupid idea, don't do it.
So based on this sample size, we can deduct that not only are sleeping babies a myth, so are natural, serene, empowering sneeze childbirths, where there's no pain really, just some pressure, that is really easy to manage with you know, breathing. And where you would actually care about having candles and whale songs around. Ha! It would not have made any difference if I had a whole Yankee Candle shop and an actual whale there..