I’d agree with pretty much everything everyone’s said so far - my daughter’s 9 months old and I had no experience at all with babies before we had her.
I guess my big message is that you’ll learn what works for you - like others have said, it’s really important that you don’t feel that you have to follow advice that doesn’t sit right with you. You’ll won’t be the same parent as anyone else, you’ll work out what feels right for you soon enough.
I’ve found that I naturally give Niamh a bit of space - I don’t rush to pick her up all the time, or hand her a succession of toys, or stop her crawling out of the room. I keep an eye on her, make sure she’s safe and let her explore her world a bit. I always try to remember that we’re all learning together - and I’m always pretty confident we’ll work stuff out between us.
One thing I’ve tried really hard to remember is that Niamh has joined a family - she’s often the most important part of that family, but there’s three of us together in this. I don’t think that your life needs to end when the baby arrives - we’ve just got back from 2 weeks travelling around Canada (including a 2 day train trip on the Rocky Mountaineer, which was a bit reckless in retrospect but worked beautifully as it happened). Life’s different now, but it just requires some accommodation is all.
Having said that, the three of us installed ourselves in our living room for the first 4 weeks of her life and never left the room. Seriously - we changed her, fed her and all ate in the same room. It felt like we were suvivors of some bizarre natural disaster!
You can’t really be prepared completely. Intellectually I thought I knew that things would change, but in fact the experience is beyond all my expectations. Nothing really prepares you for it - it’s highs and lows like you’ve never imagined. I can’t remember what my life was like without her.