I'm sure it depends heavily on your country, career field, age, income level, etc...

Most people I know were somewhere between surprised and jealous, more or less impressed that we were able to not go bankrupt with just me working and my wife at home.

Mothers especially told me they wished they could have stayed home when their children were young. I was shocked how many people I worked with had to go back to work days or weeks after giving birth.

Then again I'm a guy, so maybe it comes off as being a good provider versus taking the "easy" way.