Once upon a time I aspired to be a housewife because I'm a natural caretaker and I wanted to get married and have kids. I wound up being an unmarried childless trans masc non-binary self-employed IT professional with a dog I baby instead. My thoughts:
Being a housewife implies a sense of financial security - ie. In order for it to be possible to have one adult not working and instead staying at home in order to cook, clean, and rear children on top of it, that means that the other adult needs to be making enough money to support the home, pay the bills, cover the groceries and needs of 3+ people, right? So there is an understandable draw to it based on that alone.
There are also plenty of people (not just women) who enjoy household duties such as cooking and/or cleaning. One of my best friends is a private chef who likes to stress clean, for instance. Another best friend enjoys being a handyman.
So, I wanted to put those forward to validate those who do aspire to become a housewife or a house husband. Because its not wrong of you to want to lean into what comes naturally to you. I think its completely and totally understandable and actually a natural expectation to have - that relationship has been modelled so often in movies and TV and media that its understandable to think that that's the norm for your culture.
For instance, I am still a natural caretaker and I enjoy cooking for and taking care of those I love. I have other barriers to why I haven't done the other stuff though, namely a major paradigm shift after I dumped a fiancé years ago, age, and physical disability/mental illness/newly discovered neurodivergency. There's a lot working against me, so kids aren't in the equation anymore, but maybe marriage is with my new partner? But I still wouldn't be a housewife because of the everything, I would probably be the main breadwinner if we had to assign roles.
The part I would caution you about, is don't go for the first guy that offers you that relationship on a silver platter. Also, negotiate responsibilities within the relationship from the very start, and never give up your independence fully.
As the posters above me have said, even if you do become a housewife, househusband, or however you want to label it for yourself, make sure that you:
Have your own credit card that you manage and a healthy credit score
Have your own legal ID/passport and control over your access to it (ie. don't let them put it in a safe deposit box you can't access without them there)
Have your name on your own assets (ie. car, house, etc.)
Keep in regular contact with friends and family and have a social life of your own - your partner can become part of your social circle, but you should have friends outside of them and outside of their friends as well
Constantly communicate with your partner about your needs in the relationship and make sure you're on the same page
Keep on top of your own aspirations - take classes if you want to get a degree in something, engage with your hobbies, hone your talents, etc.
Consider working a side gig to make some of your own money if you have the energy for it - it gives you work history, an emergency fund, and a way to buy presents for your partner that they cannot track through a joint card or bank account 💜
And if your partner ever has a problem with any of this? Or becomes violent with you at any point?
You don't have to tell them you're leaving. You don't have to make a graceful exit. You don't even have to take everything of yours with you - come back later with trusted friends or relatives or even the cops. You can literally get a cab in the middle of the night and book it.
Violence does not exist in healthy relationships. Controlling behaviours do not exist in healthy relationships. Don't kid yourself that it was a one-time thing - its what we in the writer world call foreshadowing.
Prioritize your safety. If you maintain your independence in the relationship, it will be much easier to get out the moment you have to.
TL;DR: Its okay to be a housewife and to want to be one, but communicate with your partner and have your bases covered and prioritize your safety first.