It's absolutely not a rational desire. It's like biology hijacks your brain and forces you to crave having babies, even if you're a staunch antinatalist. A ton of natalist sentiment is just people coming up with excuses for this primal drive. Having a child will make most people less happy, but because so many people can't accept that they aren't in control of their desires, they gaslight themselves into thinking it will.