Hi OP,
Good question. It depends what sort of man you've got. And unfortunately you only get the answer to this once you've had a child/children.
With mine, we agreed I'd be an SAHM so, joint decision. BUT this coincided with a massive shift in his attitude to me. He seemed to have no respect for me once I didn't have a job and was caring full-time for dd. For him, with the division of roles (and, de facto, me not bringing in actual money),the balance of power had shifted - entirely in his direction! I mean WTF?! He may have supported me being an SAHM, but he seemed to think that this entailed complete subordination. I was utterly shocked. He picked holes in my parenting, undermined me, interrogated me as if I was an underperforming employee. Whenever I spoke up for myself he shouted me down or accused me of not caring enough for my dd (deeply, deeply upsetting accusation for a mother to hear from anyone, let alone 'loving partner).
My dream of being a 'happy team' - y'know equal partners trying to create happy, secure family life, with both of us contributing and working hard towards that goal, just crumbled. It became clear that he expected me to do as I was told. It wasn't a joke.
This was not what I had signed up for. I had had a baby, not a personality transplant. I was still just as clever, opinionated, feminist etc. as I was before, but I was somehow expected to be obedient. It took me a long time to recognise that because I had taken on the 'mother' role, I was hugely devalued in his eyes. It did not end well.
There was a massive disconnect, as of course I did not see the 'mother' role as any less valuable than the 'breadwinner' role. But his prejudice was entirely fixed in his head and there was nothing I could do to change the mindset. He was vile to me. Reader, I divorced him.