In my experience, the original excitement and expectation fade away slowly after birth and is replaced by paternal/maternal love, as well as different excitement and expectations. Then over a longer time, you start understanding how profoundly your life is being reordered and how you've become a different person, for both the positive and negative. No one can know this a priori.