I have a bit of a cautionary tale whatever you choose.
Gave up a successful career with good prospects to become a SAHM on the insistence of my then DH. Turned out our DC have SEND, so SAHM turned into EHE as well. I thought we were happy. He was abusive, and it took me a very long time (and therapy) to recognise that.
He decided he couldn't cope with family life and wanted a divorce. His mind was set, there was to be no negotiating or counselling. His poor behaviour ramped right up, so I began sleeping behind DC's bedroom door, on the floor to try and avoid it. I was genuinely scared at that point.
When he left, he insisted I pay the whole mortgage as soon as I was working, because the DC and I were living there.
I have worked ever since. However, what he called laziness turned out to be ME - so I can't work FT anymore. I am so exhausted after work it's not unusual for me to fall asleep over/in my tea - and that will be it from me for the evening
Eldest (20 & disabled herself) walked out on us last month. Her words "Since you've been working, I'm sick of not being your priority anymore". She loved me being a SAHM and being EHE and thinks I should have tried harder to keep her out of school (Ex threatened me, if I didn't agree to put her in any school asap). She did not react well to the change in her life.
I struggle to see what I could have done/do differently.
TLDR: SAHM + Abusive DH = misery.
He walked out.
I got work.
Eldest (adult) now blames my work for any sadness in her life.