I remember when my first was born. 2 different parts of my brain had opposing thoughts.
1 part was thinking "This is the cutest, most beautiful thing ever. I must protect and nurture them at all costs."
The other part was thinking "My god newborn babies are ugly!"
I can easily see cognitive dissonance pushes most people to the first thought. It's you being hacked by hormones, an effect that is disturbingly powerful.
I was also caught out by how much my (male) hormones were affected, even pre birth. It both disturbed and amused my wife.