I was a SAHM for 10 years, so 5ish years once children in school. I probably fall into the expat / trailing spouse category (without the expat salary unf! DH has a normal job which just happens to be in France). I didn’t speak great french, not enough to work anyway. And even once the children were in school, there was still an awful lot of running a round to do. TBH, for us, the lack of stress was priceless: sick kids, school strike, DH has to go abroad at short notice? Not a problem.
What made it work for us: we have very similar values when it comes to parenting, and me being SAHM fitted. Extended breastfeeding, no bottles, no nounous (nannies), no childcare. DH has very fond memories of coming home from school for lunch and his mum always being there. He was very keen to have that for our boys.
Career wise... it’s been tricky for me. I have a PhD, and while I’ve never been particularly ambitious, I am feeling frustrated that I’ve cut myself off from a career in «my» field. But being a SAHM is only part of that, mostly it’s down to being in a country where I’m not a native speaker - which is a lifestyle choice I guess. I’m working part time now in a fairly mundane admin job, but I love the interaction and earning some money again. I’m still around for the children, the job is super flexible and school hours only.