Every family has different dynamics, and what works for them may not work for another family for so many reasons.
I am one who has said I do not plan on going back into paid work, and I have my DH's full support.....and full encouragement .....to not return to work. My earning capacity is about a tenth of my DH's earning capacity, he doesn't think it is fair for me to work for somebody else for 40 hours a week to bring home a very small fraction of what he does. If I wanted to, not a problem, but he certainly isn't resentful or pushing me out the door to work.
I think if I had lost my spirit or my motivation or lust for life that would be an issue for us, but not bringing home a token pay cheque? Not an issue.