Very very few people in this world feel truly attractive, women included. Body image and self-esteem are almost universal problems. This is not your fault.

I suspect this is an issue of perspective. You desire women, so you believe you must be a woman to be desirable. And you desire them for their beauty, so you believe you must be beautiful. This is perspective, not objective truth. Neither has to be true of you. Only if you decide its the only option do you leave yourself with no option at all. At that point, you've decided failure for yourself.

If what you want is to feel desirable and you teuly are 'ugly' (whatever that means to you), your odds are better if you're attracted to women. In relationships, women more commonly value non-visible traits like communication, resilience, consideration, humour, and skill. Attraction is more holistic. I've known of at least two men getting married with almost no face at all (one taken off by a grizzly bear, the other obscured by large benign growths). Both had kids, too. In a healthy relationship, holistic desire grows.

You are thirsty in the desert, and that's awful. You fantasise about drowning in the lake because it looks like a solution to your problem, just as those drowning desperately wish they could stand on the solid cracked earth.