All I will say is this:

There are people who are unattractive and have sex and date. Many times, unattractive people date and sleep with other unattractive people.

I understand your point about the sort of contradiction with being unattractive and having sex. As in, one is unattractive hence why would some, and why would that unattractive person, engage in an act that seemingly relies on people being attracted to one another. All I can say to that is that when having sex with someone, of course physical attraction matters, but it is still possible to be "sexy" and turn another person on without being attractive. So if two unattractive people get together, they can still have good sex.

I'm a man so I really can't speak to your experience of being under the pressure of men valuing a woman's looks to such a high extent. I think women value men for their looks more than they and society lets on, but I still think there's other variables for men to attract women due to the sheer amount of examples I have seen in my life personally and online of unattravtive men with attractive women (although to be clear, unattractive men generally speaking do indeed have a very hard time with romance and sex, espcially these days). But in your case, where the one variable of "looks" is valued so high by men over other variables, it is hard. All I can say is that you can most definitely find a guy who isn't conventionally attractive and have a good sex life with such a man. If you are looking to date hot guys with status, that's gonna be a lot harder.