I think I'm probably going to go against the grain here and say that I've been treated with much more respect by society in general once I gave up work and became a SAHM. But the reason for this is probably that prior to giving up work, I just had an 'ordinary' job, I wasn't in some high flying career (not for lack of trying, mind you!). I had a decent job, a responsible job, but it wasn't highly paid, I didn't travel for work, and I didn't spend every waking hour telling people about it (because my job bored me, so I had no reason to believe it would interest anyone else).
When I became a SAHM, people suddenly seemed to look on us as being wealthy, middle class etc. DH has a 'professional' job and earns a decent salary, we can pay the bills without having to worry about it. But money isn't plentiful, we can't afford holidays etc (which is fine by me, we've made our choices, and we couldn't afford them if I was working either, because my salary would be cancelled out by childcare costs).
I find it quite depressing that people who treated me with not a lot of respect when I was an 'ordinary' office worker suddenly find me to be their social equal on the grounds that my husband can afford to 'keep' me. 