You have lots of good advice (and support too!) from everyone already. I will just add a couple of things that I can remember from DD being newborn. My DH works in remote areas so has a roster of two weeks on, two weeks off so I am alone for half of each month, and that included after DD's birth.

If you drive, make time as soon as you can, to take a trip in the car with someone, but with you doing all the work, as if you were alone. A grocery trip is a good one, because then you can also practice using the trolley bassinets, loading up at the car etc. Just having someone else there the first time is a massive confidence booster that you'll be able to do it alone, and the ability to get out and about will sometimes save your sanity.

Cooking for one is not much fun, and hard if you're at the end of a long day. It's great if you are organised enough to be prepared in advance and freeze stuff, but if not, my tip is the packets of individual frozen vege mix (crap can't remember the brand) a bag of frozen mashed potato ( it's quite good, much better than powdered stuff) and some sort of frozen chicken/salmon/whatever. Together, it makes a healthy meal and only takes about 2mins for each in the microwave.

I think it will all be so exciting for you, you will probably forget to be scared