This is my experience. My father had a bad heart condition that caused him to retire early. So, he was the one staying home with me while my mother worked (previously, they both worked). It ended up being fine for them. He was still very much the man of the house. They were together until his death.
Ironically, I find myself in a similar situation. Though, for different reasons. I have a rare form of Muscular Dystrophy. I’ve been disabled for the past 30 years and totally dependent on my girlfriend and caregivers for the past 11 years. What I learned from my father is you still have to be who you were before you became disabled. Women will appreciate that.
If you were a man who commanded respect before, still be that now. Whatever you wouldn’t deal with when you were able bodied, don’t deal with it now that you are not. Responsibilities that you would normally take care of before, still take care of them, within your capabilities. If there is something that needs to be done, and you can’t physically do it, figure out a way to get it done without stressing her about it. Doesn’t mean you don’t ask her for help if you need it. But, have everything planned out, how it needs to happen, so she knows that it’s going to get done without too much hassle. In other words, still be a man that she can rely on and it’s all good.
Of course, there will be women who can’t rock with you because of your home husband status. They don’t matter. Just concentrate on getting you together, shoot your shot at whatever woman catches your eye and let the rest work itself out.