I kind of have the opposite problem as a tall woman. It isn't the same, but it did impact a lot of my confidence and to this day I still dislike it very much. In general, I think women get more affirmative messaging even when they possess certain features that are considered "unattractive" to the opposite sex, like being built like a football player lol. I feel for short men because I think that they have a similar insecurity but they're put at a greater disadvantage because of the lack of support surrounding that insecurity and a lack of attention in general. I think that's really wrong and unfortunate. All of that is to say that I don't want to offer you platitudes about "finding the right woman;" even though I think that is definitely well within the realm of possibilities, I also don't think it's something you want to hear. Reality sucks for all of us in one way or another lol, all we can do is try to accept it and play with the cards we've been dealt. That's literally all we can do.
I've honestly been trying to think of advice to offer for a while. Most people will desire to be desired, so I understand how not being seen as an option to women can impact your mental health because not being seen as an ideal option for men has definitely impacted mine. On the other side, I only started to have luck in dating when I leaned into the fetishization of my height (0/10 not recommending for you, please don't do this). It sucks, but that was the hand I was dealt, so I just ran with it. If you believe you will be rejected by 99% of women, all you can do is try to focus on the 1% that won't. As hard as that is lol.
If it's any consolation, at my giantess height, I've dated men as short as 5'0". Beggars can't be choosers, I guess, but I hope from the responses that you've gotten here you can see that some women won't mind. I obviously think that focusing on physical things like height is very shallow behavior, but unfortunately that's how the cookie crumbles in the dating world. Most people looking for anything will be shallow. It's a battle to find genuine people in this world. But as someone else stated, the bright side is that if you can find someone who doesn't mind, you can basically be sure that you won't be dealing with a vain woman.
You're still a person with value even if you're a short man. It's hard to actually accept and apply even for me, but I'm (trying to) learn that our worth isn't wrapped up in how the opposite/preferred sex views us. We don't control our heights, so at the very least, we should not be made to feel shame about them. I wish I knew the solution, and I hope the best for you.