To avoid getting far off track, citing these fictions was in order to make a point about the changing meaning of "nerd". With that in mind, look at what the article you linked to says about real nerds:

In Real Life, nerds can run the entire spectrum of "beauty" and social prowess, from unattractive and socially inept to drop dead gorgeous and a social butterfly. Like most people, most nerds are simply of average looks and social skills. The only thing that really differentiates nerds from anyone else is their intense interest in niche topics.

That's agreeing with my thesis about what the concept of "nerd" has come to mean recently. The article writer thinks that it is distinguishing real nerds (who are distinguished only by intense interest in niche topics) from Hollywood Nerds (who are type 1 or type 2). But if you simply look at a dictionary (none of them have been updated to reflect the new meaning - the latest shift is too recent), the word "nerd" did not just mean someone with an interest in niche topics. By (earlier) definition, a nerd was not "of average looks and social skills". The word has been gutted of its earlier meaning and emotional impact, making it no longer, or at least less, painful for someone to call themselves a nerd.

The American Heritage Dictionary traces the meaning of "nerd" through time. In 1957, meant "square", which, looking it up, meant conventional or old-fashioned or opposed to current trends. Nothing there about intense interest in niche topics. Then in 1970, an uninteresting person, a "dud". Again, nothing there about intense interest in niche topics. At some point, the concept of "nerd" gained the element of keen and single-minded interest in niche and especially technical topics. while retaining the "dud" element. But now we see, in the article you link to, that "nerd" has, at least for some, dropped the "dud" element and retained only the (relatively new) element of interest in niche topics.