Just for another perspective, I think sometimes we do too much coddling of **holes in our society. There's a strong pattern in our culture of so-and-so acts in a really offensive way, and then everyone says to the person offended, "oh, never mind him, he's just sick/unhappy/in a bad karmic place/doesn't mean it." When really what we need is to have OUR hurt be validated, and for so-and-so not to get to be and **hole! In other words, we make a lot of excuses for the offender, which just serves to erase/undermine the ways in which he is offending everyone.
So, OP, I like Mmmm....Donuts' response, but also remember that you have the right to tell the truth in a way that doesn't have to be escalating. Something like, "you know, John, I really disagree with you there; in fact, I think getting out of the workforce is a moral imperative to allow young people to have a turn, which allows the economy to grow. I'm really happy with my choice, and given that we are friends, I'm a little offended that you would essentially call me "useless", when you know perfectly well that I have a rich and fulfilling life."
In other words, tell your truth calmly, and then let it sit there for HIM to deal with. He's allowed to be uncomfortable too. If he's caused the awkward social situation, YOU don't have to be the one to suck it up.
(I know it's INCREDIBLY difficult for women to cause awkward emotional upset. I share that pain. But I am learning. :) )