Is it weird to wanna be a husband but not a father?

Not at all.
It's natural to want intimate connection with another.
But with climate change likely to accelerate (because not enough is being done to slow it down) this is not a good world to bring kids into.