This is such a tricky one and will depend so much on your family's individual circumstances.
Until recently, DH and I both worked full time with two children - one in nursery and one at primary school. But because DH's commute was an hour and a half each way and my commute was only 30 mins, I was doing all the drop offs to breakfast club, all the pick ups from after school club and nursery, all the drs appointments, all the parents' evenings, the ballet rehearsals, the cooking, the bath times, etc, etc. DH would leave just as the DCs were eating breakfast and walk through the door just as the DCs were going to bed.
I tried dropping from five days to a four day week (work wouldn't let me do three days). But I found I was stuck in that classic trap of trying to fit five days' worth of work into four days, plus we could no longer justify spending on a cleaner, so my workload increased at home too.
Oh, and in the time since we'd had our first child, DH had been promoted and his salary had doubled, while I was still treading water in the same role and had been on the same salary for five years.
I was constantly exhausted and stressed and getting nowhere in my career because I couldn't put in the overtime or the hours of necessary networking. And after paying the nursery fees and the breakfast and after school club fees, we were only about £200 a month better off with me working.
All the arguments about keeping financial independence and your own pension and keeping a foot in the workplace, even if it's part time, are all valid - and they might swing it either way, depending on the industry you work in, the state of your marriage, and your DH's job security. But for me, none of the stress and the demoralisation as yet another junior, childless person was promoted above me, was worth it. My self-esteem dried up and I became depressed.
Eventually my DH said fuck it, leave your job. Life's too short to be so unhappy for such a large chunk of your day. So I became a SAHM just a month or so before the lockdown happened. The timing was actually pretty good considering that I'm now having to home school and DH is working from home and busier than ever. I've now got a place at uni in September to train for a completely new career. I'll be starting from scratch but I feel like a huge weight has been lifted and I'm excited about life again for the first time in years.
I guess what I'm trying to say in a very long-winded way, is that only you know where your line is. Some people will tell you they get up at 4.30am every day and do a two hour commute and only clear £50 at the end of the month after all the wrap around care is paid for, but they don't want to lose their foothold in the workplace or their financial independence, and that's fine if they're willing to suck it up. Personally, I wasn't. The trade off wasn't worth the impact on my mental health and my general wellbeing.
You need to make the decision that's right for you alone. Don't let anyone make you feel guilty either way.