This article is a step towards understanding not just by people of nerds, but by nerds of themselves. I was 17 when someone recognised these aspects f the nerd in me, and made me see them myself. Net result was that I made it a project to make myself socially capable.
In the main I succeeded, although there are still occasions when I slip and fall, but it was recognising and accepting the truth that made it possible to change.
The article is right as it stands, as indeed you actually acknowledge when you say "Nerds have to realize ... they are performing a trade-off."
Of course, this is for the nerds who tend to over-analyze social situations for fear of screwing them up; there are also the kind who just have no idea what is considered "normal" behavior in the first place, so they don't have enough information to even choose to obey or disobey social mores. In the latter case, I'd advise "critical people-watching" to figure that kind of thing out; your nerd will then likely transition to the over-analyzing type once they have this large, novel corpus to pattern-recognize over.
In the days of my youth, nerds often were trapped in a high-school society that had no need for them at all, other than as targets. Many nerds only recognize the grown-up version of society as a continuation of this. To many, it's all just a system of oppression. The "cave" that they construct around them at work is just a refuge in the storm.
Note the highly escapist nature of many nerd pastimes. For many, programming is itself of of these.
I think the nurturing of a nerd to sociability has to do with power relationships. I think the problem is releasing a nerd from his enclosed "cave" into a larger world of social interaction, without unleashing his/her potential for tyranny. It's like contacting a race of fierce equestrienne nomads.
Do: Open trade relations. Mutual exchange & benefit! Gradually.
Don't: Open a breach in the wall and have the barbarian hordes pour through. (The charge can happen in both directions!)