I don't see a problem, usually. in some families, women earn enough for that to happen. if the dad worked, a lot of his pay would end up being taken out for child care and such.
I do see how it could create conflict, though. even today, men are expected to be the primary earners in marriages. even if the couple is doing well and they do not see a problem, community and social pressures could (I would think...) potentially cause stress and conflict.
my best guess is that the social pressures on the couple--the man, in particular-- might be more intense in a lot church settings than in the world at large. Just a guess, but...yeah; here where I live, at least, Protestant Christians tend to be to the right of most people, so I could see "church people" causing stress in the family unit, through their ideology and outlook.
probably varies, case by case. I had an acquaintance in public school who had a "stay at home dad," but his dad had done the corporate thing, made his $$$, and then the family bought a place around here. the wife did high dollar real estate, so...w/ that kind of $$$ and status, nobody ever gave him a hard time about it.