Warning, Im going to answer your question very honestly and it only reflects my experience, no one else.
I did leave my job and I loved it, it worked for us until both kids reception (so maybe six years in total). I loved being able to do what I wanted to do whenever and not have to answer to anyone. My kids loved having me around as did DH. But during that time although I loved being with the kids and wouldn’t change it entirely, i felt my identity morphing into simply being eg “jack’s mum” Mr Gate’s wife, everyone’s cook, cleaner, PA, taxi, gardener, the lot.
Whilst I made (and kept) some great Sahm friends, I often found that as a group despite everyone being fun, intelligent, interesting (especially when we were one on one), as a group (which we often were) the chat would would always revert back to talk about schools, housework, fancy dress costumes, mundane stuff. Beyond that the most exciting talk was decorating, house prices, renovating, building an extension, the gym. All very interesting the first time round but I felt I was really losing myself and my sense of purpose.
On top of that, the more I did at home the less everyone did for themselves, and I became resentful of the feeling that my job was really to enable everyone else’s life.
So for me I couldn’t continue any longer and I refrained and went back to work. I don’t want to say what, but it was NOT an easy process and I’m eagling about 25% if what I would have been had I stayed.
My advice would be just don’t close any doors, it’s almost impossible to open them again later no matter what people say, and it’s even harder to think of something new you want to do that isn’t then all consuming the other way (too much time away from home). If you want flexibility, the best way to achieve it is in a place where people know you already. Otherwise it’s very hard for them to trust and get to know you in order to make flexibility work for everyone.
It’s a precious time and time out you won’t regret, but I’d say to base how you do it on what you might want in five years time, not simply now.
Sorry for the long post!