What is the goal of having kids though, from a personal perspective? Sample size of 1, but even looking around my generally stable middle to upper middle class

What is the goal of having kids though, from a personal perspective? Sample size of 1, but even looking around my generally stable middle to upper middle class social circle, I feel like despite putting your best effort in, it’s a 50:50 coin toss that you’ll be in your later years with a wonderful relationship with your adult children versus having them be virtual strangers or even estranged. Is that considered meaningful, and worth the sacrifices? I see a lot of elderly people who never see or hear from their kids other than a phone call during birthdays and maybe a visit during holidays, even if they live not too far away. I would hate to be in that kind of relationship with my future child. My wife and I see our parents multiple times a month, frequently eat out together, and even air travel together at least once a year. I would love that kind of relationship with my child, but I feel this is a massive edge case, not the norm, especially in American society.