I'll anecdotally confirm this. As much as people love shitting on the awkwardness of nerds, most people get it together enough to find love by age 25.
People learn enough social niceties to get by, even if they never become the life of the party. Women start caring less about how cool the guy is and and start caring more about "Do I actually get along with this person?" Somewhere in the middle of those lowered expectations for coolness and increased social competence, nerds do just fine.