I'm not a parent. There are parents that regret having children, but their voices aren't heard that much. There's more content surrounding mothers who regret having children than having fathers who regret having children.
Right now, if you are a man thinking about having children with a woman, there's one important thing to consider. If you have kids with a woman today, you are more likely to not be in a romantic relationship with that woman by the time the first child turns 18 than you are to have stayed in the same romantic relationship for all those years. I don't think it is a good idea to subject a child to a broken home. I was raised in a household where a divorce occurred. The divorce didn't occur until I was in high school, but my parents had an unhealthy relational dynamic for the entirety of my childhood. It is astounding that my parents were together 20+ years when they had no business being a couple for more than 6-12 months.
I have always been unmotivated to have children. For men that want children more than I have wanted them, they face a challenging decision. You're correct that people get into LTRs and eventually get married for the sake of having a stable home for raising children. That stability is a illusion. Many men end up divorced. Just look in this "Mature Man" thread right now where
@Machine10033 got some texts from an ex married with children to a doctor. This ex wants to have sex with
@Machine10033 and her doctor husband might not even be aware she's looking for new penis.