The fear of “ew no” is real, but also not nearly as big a deal as you might think.
“Ew no” is at its most powerful in small, isolated communities, where a single “ew no” from the wrong person can have outsized reputational damage. Think high schools, small towns, etc.
As you get older though, you have a lot more opportunities to meet more people who have zero relation to anyone who might’ve said “ew no”. Pretty great that way.
But there’s also the more intimate damage of “ew no”, just that it hurts to be rejected or thought of that way. The good news is that anyone who would say “ew no” is legitimately not anyone you want a relationship with in the first place. Neither of you would be happy together, so their rudeness aside, they’re doing you a favor of not wasting your time with an unhappy relationship. Seeing the bigger picture there really can help with the ego damage from “ew no”. Their reaction is more a reflection of them than it is of you, and recognizing that really helps with confidence building, too.
Sorry for the ramble. I was a nerd in school back when that wasn’t cool. But I’ve been happily married for a while now, and it would’ve never happened had I not been willing to risk an “ew no” from time to time.