Mmm.
I worked full time and it was hard and stressful but ultimately fulfilling and I was proud of what I achieved. I was wracked with guilt for missing things and sometimes resentful of missing out on my kids but for me I think it was the right thing.
At the same tine I remember my GP saying that many SAHM women in my area were on anti depressants (something borne out by my SAHM friends ). These women were all generally intelligent, educated people who'd had high powered jobs before stopping (mainly because DHs jobs were so all encompassing that 2 parents working made no sense). Many of them seemed to be like (rich!) single parents for the most part. That's so hard and isolating.
As with all things I think balance is important and as your children change and grow they and you will need different things so be prepared for you and your partner to flex and change.
Whatever you decide the domestic support arrangements are crucial. If you end up working and doing all domestics then you'll break. You need a solid shared arrangement, including mental load (like remembering birthdays and planning for Christmas and social events).
My advice would be to look into your heart and listen to what it says. Don't worry what people think of you or what you "should" do. Do what feels right snd keep it under review and change /tweak if you need to.
Having kids is wonderful but don't lose yourself entirely.
My kids are big now and proud of what I've achieved, and they have fed off my drive and energy. Plus they enjoyed the logistics of having nice holidays and secure housing. But it wasn't perfect snd I missed out on quite a bit in sacrifice of that.
Long response but hope it helps. Summary :there are no easy answers. Follow your heart and review regularly. Do it in partnership. Relax as much as you can.