Seriously, OP, most people are average-looking/slightly above average, a minority is good-looking and a yet smaller minority is ugly as f***. We belong to the latter, and we can only get over it. Genetics condemned us, that's it. Accept it and move on.
I don't think we can use a bell curve or use the term "average" (for looks) as we would normally use like when measuring intelligence. Sure, when measuring intelligence, you can measure objectively (to a degree). With looks, it's a lot more subjective. When women are bombarded with images of very good looking men all day long, suddenly the "average" looking guy seems uglier. I'm back in the UK for a couple of weeks, and was at a service station yesterday. I couldn't believe me eyes. Almost every guy I saw looked ugly. More than half the guys were slick bald, if you want to include NW2 upwards, that's probably 70-75% of men I saw. Just so many physical flaws - weird faces, weak jaws, overweight, bags under eyes, awful posture. It was like a freak show, yet I caught myself and thought "maybe it's just my perception". I never used to see men that way. Before, it was just a case of "oh, look, a bloke" (no judgement). Maybe I've been "looksmaxing" for too long and my radar homes in on physical flaws.
I can see the same thing happening with women in that horribly, male looks are becoming more and more important to women as the male role of being provider is being eroded away to nothing (welfare, more women in professional roles, women outperforming men at education). Now, men are (horribly) being seen more and more as peacocks. We have to present ourselves well. Now it's about quality of sperm (good genes) much more than being a provider. So...then you get a survey like this where 10% of men are seen as attractive. Go back 40 or 50 years, and if you have a good job regardless of your looks....society looked up to you and saw you as a "good catch" for a woman. Now? The same guy is ridiculed if he's short, bald, weak jaw, any flaws. He's a "nerdy loser" even if he can provide. Men have nowhere to go when society moves in this direction. It's become a lot more ruthless toward the male and his role.
The corollary to this is that the male standards for a female partner have lowered. Women don't need to try as hard - they can be very overweight and unhealthy, a plain or ugly face, have a boring personality - no problem. Furthermore, the societal shift toward the female has enabled some very bad behaviour by women. They are not held in check like men are. If you dare criticise, you are a misogynist. Men have a short leash (held by society), women a much longer one.