Not counting the women of my mother's generation who all had to give up work on marriage (although one of my aunts never had a job at all, not even before marriage. It seems odd to think she never got a paycheck, never had such a universal experience of going into work.)
My husband's aunt has never worked. She is a lovely woman with an excellent degree, speaks several languages fluently. She could probably have done several interesting jobs. She never married or had children. I think she had mild depression and anxiety which stopped her - and there was enough family money to mean she didn't have to support herself. Her retirement is pretty much like everyone else's.
My friend's sister had one job out of college for about a year, married, gave up work, and has never worked since. again, I think it was avoidance of life to a certain extent - she is pathologically shy. she reared her children and took care of elderly parents but has very few outside social contacts beyond family.
I knew one woman living off social welfare, four children, deserted wife. her mother had been the same - deserted by husband, but she worked all her life as a cleaner to support herself. This woman's siblings worked and made good enough lives for themselves but she just stayed stuck in sw. It was a hard life in many ways - council house, but it was damp, no big treats besides cigarettes, nothing much to look forward to. She died young enough of a chest infection. One of her children got out of the cycle. The other 3 live similar lives.
In general, I think people are happier if they have some sort of employment, whether it is volunteered or paid or whatever.