I've been the one working out of the home with a spouse at home and I've been at home with a spouse having to be a carer because I got really ill, and with having a spouse work from home, and now he works out of the home while I work from home. All the combinations fit different needs and have risks, responsibilities, and possible benefits.
I don't tend to think about others unless I get someone complain at me and then do the opposite of changing their situation or parents who live through their children/treat their children like their meal or meaning ticket. The latter happened a lot when I was growing up. Really, back then or now, all the happy SAHP had side projects or significant hobbies separate from their family lives, often ones that either brought in some money or fit into something they later did, and all the miserable ones had distractions, but not much of substance (kinda like retirement).
With my mother - she was SAH until I was 11, then she was a lunch lady for a bit for reasons outside my awareness, then SAH for a bit, then my parents finally fully separated and she worked at a local electronic store irregularly as my father still paid for the house and things for years (even after she kicked us all out, it was a weird situation). I spent a lot of my childhood hearing about how I or my siblings were going to make it in whatever she felt like at that moment and buy her a house & it'd be our turn to take care of her. That was a lot on little shoulders.
With my children, my older DD has asked about what work I do, when I talk about something she'll ask if I'm getting paid. I used to worry about it when I was trying to transition back into work and doing volunteer things, as she couldn't explain why she was asking well, but I now think it was more that to her I seemed to work a lot (whether it was around the home, life admin type stuff, or freelance work) and she just didn't entire get the changes beyond my being on the computer more & occasionally having a few days of deadline ughs. Now she's doing careers in PSHE & we have a lot of nice chats about priorities and life options with different kinds of work.