Need serious positive inputs

*****Please no judgement! My husband and I are in a very happy marriage ****
So! First off I am 9 months Pregnant about to give birth any day now. Something came up in discussion the other day with my husband and it's been driving me crazy and making me way more upset then I need to be.
My husband and I have been very sexually active our entire time together and marriage. He's active duty army so literally when he is home we have sex every single day and sometimes more than once and twice. We've been this way since we were dating and started living together. We never get bored and we are always trying new things. Sex, for us, is our down time and if we miss a night because we were too tired or whatever, we usually both feel deprived. I am honestly so happy with my sex life and I know he is too.
So now being pregnant we remained sexually active to this day. Obviously it's not as enjoyable than before because I'm always so uncomfortable half the time. But he expressed to me the other night that our sex life will never be the same when our son comes. He explained to me that our lives sexually are over and we will be lucky to once a week. I never thought about this before. I would hope that this isn't true but now the more I think about it the more I am seeing that it may in fact be the case.
Could someone PLEASE give me their own personal success stories with sex after having your first baby. I don't want one of the things that me and him enjoy so much to stop because of our son. Or am I just not being realistic and have to accept that it will have to..