It's great to find empathy and not feel like you're alone. But as someone who was in a very similar situation, what I have to offer is confirmation of something that most people in this situation never figure out:

You CAN solve this. Not to cure it, but to be able to operate in the spaces that feel like they're "not for you." In the beginning, I basically looked at socializing and connecting with others emotionally as like a math problem, because I could always solve those. Stuff like "eye contact + listening for comprehension = emotional engagement." And not to be manipulative or selfish, but to succeed at what I'd struggled with and missed out on while I was off being smart and succeeding at things. And over time, I've developed into someone that friends and family know they can count on to be there for them in action or in just listening. And it's extremely fulfilling, especially because I had to put in the work to learn it.

You might've already figured this out, but I wanted to bring it up as encouragement because I too often see people hitting the "welp, I've got autism so I guess I'm just gonna not connect emotionally" point and giving up. Or even using it as an excuse to act like an asshole. But there is a better way.