Scared Shitless, please help!

You friend seems to have forgotten the most important thing about having children. Once that child is born, it is no longer about you. Nothing in your world will be about you any longer. You're worried about not getting any sex when you should be worried about you and your wife getting more than a few hours of sleep at a time. Men were taking care of their needs long before the got married or had children. Take 5 in the bathroom, and then make your wife feel like a queen. When life returns to a more normal pace after the baby comes, she will treat you like a king in return.
 
I'm surprised your fertility doctors didn't warn you about these feelings beforehand. When my mother had me in 1965, she was warned by her doctor to expect post-natal depression. He prescribed tranquilizers to her, and she did a pretty good job raising me and my older brother. Perhaps you should look into getting tranquilizers for yourself. It is also possible that your wife is also overwhelmed and might need them after the baby is born. And taking them is nothing to be ashamed of. I'm bipolar, and my meds keep me on track.