My wife was employed when our daughter was born (oh lord 13 years ago) but we had hired help (this was in India - that was a very affordable option). Eventually she decided to stay at home because she wanted more family time and quite possibly that's the best thing that ever happened to our family.
Suddenly all of us had time and the luxury of one person with flexible time is amazing.
My career hit an exponential growth after this and she has a major hand in it. I am able to enjoy a cycling habit (20hrs every week) because of this.
It was a hard decision at first. Obviouslt financially, we also hadnt accounted for how much of our identity was defined by the job, so that was interesting. Navigating friends and family who considered that to be THE defining thing was also interesting :). I obviously have a lot to write on this since it is still a thing :)
Overall Id suggest it to anyone who is willing and able to try.