There is no one reality.
For some it is unspeakably awful and for others it's a wonderful, magical time. That's why you hear both types of stories.
A lot of it will be down to what sort of baby you get. You just have to wait and see.
Things you can do now that will be helpful no matter what type of baby you get:
Batch cook some meals for the freezer.
Make sure cupboards are well stocked so you have what you need at hand.
Either get a cleaner or lower your standards around housekeeping (unless they're already dangerously low of course).
Do not be afraid to seek any help you might need for PND or similar. If anyone offers help take them up on it, be clear with what you'd like.
Get off social media (or just stick to dog/cat videos). Do not compare yourself or your baby to other people.
If you can, let other people hold the baby. Not random strangers on the bus obviously, but grandparents, close friends and most importantly your partner. They won't come to any harm, having that support helps immeasurably and a baby can't be too loved. You may feel that absolutely no-one else can comfort you baby, but that won't be true.
Make sure you have comfy clothes, some netflix series lined up, comfy sofa and blankets, water bottle etc.