Any hope?

Is there ANY hope of me having a newborn that sleeps through the night? I have a 2 year old son that sleeps literally on me and wakes up if he knows I’m not in bed and I’m super freaking out on what’s gonna happen once the baby is here... any tips?