Oh OP I feel you.
When I was pregnant with DS all people wanted to discuss was either how big I was, what sex he was or how awful parenting is.
You cant go out, you dont have freedom, you cant do this, they're a pain in the arse... blah blah blah... negative negative negative.
We only had one person say "Oh you're gonna love it, its awesome".
And it is. As far as I'm concerned.
You know you'll be tired (but you'll get through it), you know you'll be stressed (but you'll get through it).
Parenting is fucking awesome. DS is now 2 and he is brilliant!! That moment when he was put on my chest to feed. The moment I saw him in his father's arms. The moment my family came up to see us in the delivery room and marvelled at this little baby who had arrived. Those were amazing, unique moments and I wish I could have taken a picture to show you. That amazing feeling carried on and developed.
We fed him in the wee small hours if the morning. We played peek a boo. We watched him try to crawl. We watched him taking everything in. We watched him grow. I cried, I laughed (lots), DP and I argued, we made up, we did all the things that make you close as a family and we're still really close knit today. Not perfect (nothing ever is) but close enough for us.
Every day continues to be amazing. Every day brings new wonder and excitement. He still astounds me. I look at him while he sleeps and feel overwhelmed sometimes with how much joy and happiness and love he has brought.
It will be hard, sure. It will be an adjustment. But so far, in my experience, it has been one hell of a ride.