It's really not the word it used to be.
That's only useful for making an us vs them label. It's a good thing that anyone can nerd out on Dickens.
I've heard before that it's a question of degree (“prove just how much you like Dickens!”), which is kind of an uncool way to discourage intellectual curiosity. Not everyone was forged in the pale glow of monitors in their parents' basement, some have to work at it later.
An alternate interpretation is that 'nerd culture' has become an ugly perverted commodity of its former self to the point where the requisite "hot girl" is put in front of eyeballs with no authenticity and offers semi-humorous-because-she-doesn't-quite-get-it-but-still-tries-her-best one liners while simultaneously manifesting this new proto manic pixie dream nerd girl persona-having no real purpose or reason for being there other than to rope in the casual viewer looking for something, anything, anything but another TCP/IP joke.
Physically attractive people can be nerds. Nerds can be physically attractive. But let's not fool ourselves on those tropes that still exist and get trotted out there making everyone look like damn fools: The hot girl who tries to be nerdy with a front as transparent as saran-wrap, and the incapable, slightly awkward-looking but you can't figure out why nerdy guys who pine after her because she totally understood how heavy the ending to Empire Strikes Back was and enjoyed it.
I call "The Big Bang Theory" to the stand.
Being "attractive" is usually more than just good looks, it takes a lot of time and commitment. Even the most naturally attractive people can be pretty unattractive if they entirely stop caring about their looks. Hell, just keeping long hair looking somewhat presentable takes a few hours a week (as I found out when I decided to grow my hair out back in highschool, didn't expect that). Add in time to go to the gym, buy groceries, cook and eat properly, find/buy well fitting clothes, etc and it adds up. If you're nerd-level passionate about something, that's all time you could be spending on your passion of choice instead.