I think there's an idea of a traditional family set up of woman births, feeds, nurtures children, keeps the home clean and tidy, cooks meals for the family and supports the man who brings in the income.
There is nothing wrong with this arrangement.
Only a woman can breastfeed (I realise not all children are breastfed) and so it makes sense for other duties to come alongside this. It is best for a baby to be with their mother right after birth so they can feed, bond, and also why on earth would you not want to be with your baby? So a year at least is necessary off work.
Sans children? If a man can afford to have his partner stay home so that he comes home to hot meals and a clean house daily without having to worry about those things whilst at work – this is also brilliant for both involved.
I have one child and consider myself something of a housewife given all household duties fall to me. I raise my child, I educate her at home, I provide all our meals freshly cooked.
I also have an active social life and I work from home.
Labels are just that, and if you don’t enjoy the label housewife don’t use it. I enjoy it and I embrace it. I'm more than happy for him to go and make the main income. If he made more and I could give up work completely I may even do that, though I'm used to working now and have found jobs I enjoy doing.
In life you should strive to get the situation you want for yourself personally, and yes that will often fit into social norms because social norms are often born from things which work well.