The short answer is: no. There are lots of awkward, autistic, shy, or otherwise not great with certain social situations people out there who end up in happy relationships, both romantic and platonic.
The longer answer is that, if you're someone who really struggles with social interactions, including flirtatious ones, there are different ways of approaching that. Sometimes people address it as part of therapy, or learn strategies and techniques that help them gradually feel more comfortable talking to people. Sometimes people gravitate towards spaces and subcultures where awkwardness is less remarkable. A lot of nerdy spaces tend to be home to people who know what it's like to feel awkward (and, in my experience, sometimes neurodivergent people will be drawn towards those spaces BECAUSE there's more room for different ways of interacting). And yes, sometimes what people do is accept that the awkward or anxious aspects of their personality are kind of how they are. As someone who is awkward and often socially anxious, I know I've done all of the above at various points in my life.
I know we've linked you to Dr. Nerdlove in the past, and he addresses the question of how to build confidence in social interactions as a nerdy/awkward/shy guy pretty often. Have you had a chance to look at any of that advice?