When we got married, DH was a teacher and I was starting in a city-type job, out-earning him by a lot. He went back for a post-grad degree and I was the sole earner for the next three years. We ended up juggling two pretty intense careers and three DC until I decided to take a step back and stay home. I wasn't someone who would ever have imagined myself becoming a SAHM, but I actually loved it.
I loved being able to relax the pace of our lives, not have to deal with nannies and childcare, and crazy diaries and travel. It was lovely being able to be really present with the kids as they entered the tween and teen years, and I got to do so many things I'd always wanted to do and not had time for - volunteered loads (which led to the job I do now, which is about 20 hrs/week), did a second post-grad degree which added to my qualifications, got pretty fluent in a second language, did some writing that got published, did some freelance work, project managed our house renovation.
But I didn't go searching for this, it just kind of came about organically, and I don't think it would have worked if I hadn't felt I was in a marriage where we were on equal footing or if I hadn't had a pretty good sense of myself beforehand.
So I wouldn't jump too fast, @PoliteEagle. Plus, as a pp has pointed out, being able to have a child isn't guaranteed. Choose someone you'd want to be with even if the setup you're looking for never happens.