It's an incredibly personal journey, and reality is that everyone's experience is different, so even people who have anxiety during pregnancy and then fall in love at the moment of birth can only really speak for themselves.
Also, society doesn't really accept that for some people, having children really just isn't what they envisaged, because we pedal this notion of having a baby being the most natural thing in the world and how the rush of love is all consuming, so for those people it doesn't happen for they don't feel permitted to have a voice, iyswim.
But if you think about it, we even have animals who are non maternal. How many baby animals are abandoned every year for instance, or even killed by their parent because of illness/disability, but we accept that because it's an animal and yet having children is a fairly basic animal instinct iyswim. Not that we'd condone parents abandoning their babies obviously but perhaps if people felt more permitted to being able to talk about these things we would have less issues with children growing up with non maternal parents, and the pressures of how people ought to feel. And perhaps this might even make a difference to e.g. The levels of PND currently experienced. After all, how many people talk about not liking parenthood and we put it down to hormones/depression/metal illness when actually, maybe it's just that they don't like being parents.
For me other people's babies never did it, not before I had one of my own and still not. They're cute and all but that's about it. My own was my world, and at fourteen he still is. But although I wanted more and nature didn't intend that, I'm now at the point where no way in hell would I want another one.
And I know the two opposite ends of the spectrum - one friend who absolutely detested babies, never wanted any, had one to make her dh happy, hated being pregnant and then fell in love as soon as he was born and instantly wanted more, now has three of her own and three DSC from her second marriage. And interestingly people say that she just didn't know what it was like and this was all natural. The other person I know however struggled to conceive, spent eight years having fertility treatment, had it planned to be a sahm, eventually fell pregnant and hated being a mother so much that she went back to work early. And yet society doesn't accept that. She must have PND/must have some kind of imbalance/there must be some reason behind why she feels how she feels. But to her she just spent so long thinking about having this baby, that when the reality arrived she realised that actually, being a mother was about so much more than that, and she didn't like it.
You need to do what works for you. Don't have a baby for anyone else, as hard as it is having a miscarriage, that pregnancy has given you an insight into the being pregnant bit and the looking to the future. If you feel you can't go through that again, then don't. But do have an honest conversation with your DH so that he can make his own decisions accordingly.
But whatever you decide, there is no right or wrong answer.
.