Are you supposed to love your child unconditionally from the moment she arrives?
The conventional wisdom will make you feel like that is the only way, but for some parents it might not be the case. For various reasons a child might cause physical and emotional pain, and it takes time to get over it; years for some. The best thing you can do to get through this faster is to talk with your significant other.
What does it feel like to have a brand new child?
It might feel overwhelming, and depends on your situation, you might find yourself less than excited about the arrival of your child. Thing you enjoy doing in life, life travel or sleep, might get rudely interrupted and put on hold for a long while. It happens to dads and moms everywhere, causing a lot of emotional problems, but this subject is rarely discussed publicly, and even your friend are unlikely to share until you have a child of your own.
What is some valuable insight for first-time parents ?
There is a lot of worry about every single problem. Take the pressure off of yourself and don't worry as much. There is enough stress as is with lack of sleep, disruptions in lifestyle, etc. Just focus on your child, the present moment, and the core responsibilities of helping them thrive.