In my opinion, based on the women I socialise with (late 20's) and our experiences with our own mothers (now in their late 50's/60's) here's what I think;

Most of our mothers didn't have much in the way of a "career". Most of them worked, at least part time or at least when we were older, but they were in no way career oriented. So we saw them doing fairly low paid, mundane jobs and also looking after their kids (us) while our dads had the better paying/more interesting/more challenging jobs.

A lot of our mothers wanted us to have more than they had. So we were taught from being young kids that just because you're a woman, doesn't mean you have to stay home and just have kids and not go to work/not pursue a career you want. You can/should have a career! Try hard at school!

So we all finished school and got jobs and tried to pursue careers. And we did that for a few years and now (in our late 20's) we like our jobs, or we're succeeding in our career paths, or whatever. We have our own money. We have always had our own money.

So my knee jerk reaction to the question, "would you want to be a stay at home mother?" is FUCK NO because my life is great and I'm not even sure I want kids, I dislike the idea of being stuck at home looking after kids while my SO goes to work, I hate the idea of not earning my own money, I hate the idea of being fully dependant on a partner, I hate the idea of losing at least some of that time/energy invested in my career, the fact having kids would at least stall my progression, the fact women in my workplace tend to be taken less seriously professionally when they come back part time because they now have kids... I could go on.

So if money was no issue, would I? Maybe for a couple of years, but no not permanently. Too much to lose.