congrats. as a father of 3 boys I can tell you your sex life is not over. might be on a short hiatus while she is in the later stages of pregnancy. my SO was always a horny little woman, but after child #2. she really craved my cock. I did a little PE while she carried #2, and she noticed it when we resumed our sex life. I went from large to larger, and nothing wrong with her waking me up with a BJ, and riding the fat boy in the middle of the night, after a baby feeding or she felt the urge. she also got into a little cock worshipping, and at one point wondered if something was wrong with her because she thought of my cock constantly. somedays she could hardly wait for me to get home. she used to be in bed, ready, when I came home from work. the piece of meat between my legs was never happier, and performed flawlessly. the only thing that stopped all this, was she had a hysterectomy at an early age, and it went down hill from there.
my advice on your social life if this applies, is...."babies and barstools don't mix."
and being a dad is way cool. I am in my 50's with my 1st grandchild on the way. friends that never had kids are starting to feel left out or incomplete. they used to give me shit when the kids were little and now I think they know they missed something pretty darn good. your priorities change or they should change if you want to be a good dad. a good home, stable environment become your major focus. remember the hand that rocks the cradle holds the future of the world in their hands.
I am envious ofyour sex life, man. Mine was ( and is) not much, regardless of babies.
To the new dad I say, You will cherish this. Nervous or not, ask for help from older, more experienced dads.
Also, pray for a boy ( that IS how sex is determined, right??) so you can introduce him to the joys of wearing a jockstrap and jacking off.