I am married with dc but have a lot of friends who are single and childfree in their late 40s and beyond. They are all individuals so I don't want to lump them together; I can't say they are all happy or unhappy, same as with my friends who have families.
I guess some general points:
- they have had more time to spend on their careers and all found things that fulfill them in some way - either materially (some have high flying jobs) or satisfaction
- they have had more time to develop close friendships and relationships with other family members, so have a rich social life when they want it
- they have more money to pursue hobbies and travel
- they will on the whole retire earlier
None of them talk to me about being sad about missing out, even the ones who really wanted a relationship and kids. We used to, in our twenties and thirties, but less so now. They all have other childfree friends who they may feel more comfortable talking to about that. They sometimes mention how hard it is when people talk about kids or grandkids a lot - and how boring it is.
Oh another downside is that they tend to be expected to provide care for elderly/sick relatives if they don't have kids to look after; they are expected to be free. However, this may just be a general female / personality thing .. my DP expect me to do more for them than my DB, even though only I have kids. But that may just be that I am better at it and they know I can cope!
I work and live in a pretty liberal place and I think that helps - yes lots of us are married with kids but lots of long term single people too. We have all travelled (TEFL background) and not followed the same path, and very few of us are local. Variety of nationalities and LGBTQI (university) - so it is an inclusive community, at least Compared to my DH's workplace, where everyone is local and married with kids.