These stories told are always anecdotal about people preferences and choices.
Long and the short of it, we are little more than animals, our job is to arrive, procreate, nurse until the litter is self sufficient, then shuffle off. Genes perpetuated, job done.
On to the anecdotes. I have two sets of friends who didn't have children. Set A chose not to because of medical issues, Set B chose not to because they liked the child free lifestyle.
Fast forward 50+ years, Set A have a lovely life, devoted to each other still, involved in the church, so any 'gaps' have been filled by being uncle/aunt, god parents etc. They are satisfied with their life. On the other hand Set B, now regret deeply that they have nothing to fill their life with, yes they had the holidays and the trappings of wealth but in reality they are very lonely and cant join in conversations with their peers about grandchildren. Oh they tried ;adopting' ours as surrogates but lack of actual ability to parent and interact appropriately with children means that failed.
As they say, no pockets in shrouds, and all they have is their bank accounts to console them - and memories of the QE2 circa 1970 when it might have been something special.
Of course no everyone with children is a decent parent, and being a parent is no guarantee of your children actually bothering to spend time with you in old age either . I see a lot of neglected old folks in my line of work, usually the adult children refusing any care for their parents because they might have to pay out for it, they circle when a death is pending and they want to get their hands on money.