I would never want to be a housewife, and I wouldn't want my parter to be a housewife/househusband either.
I don't mind it if both partners are OK with the arrangement, and the partner working earns enough to support the other partner and child(ren) but as soon as the couple start running into financial difficulties, or needing help from the State/parents, I strongly disapprove. Until kids are school age, fair enough, have a stay-at-home parent if it's more economically viable than paying for childcare. But once kids are at school, parents should be working.
Being a housewife or househusband without having kids sounds to me to be the most boring thing ever! I just don't understand why anyone would want their entire day to be about cleaning, cooking and doing hobbies. I certainly don't understand why somebody would want their entire day to be about those things, without contributing anything financially to their relationship.