I think to some extent, it is becoming more socially acceptable to be a bit nerdy.
Although with comic books, they've always been fairly popular with a huge number of people. And the people who are obsessed with them are still looked on as weird.
The same thing applies with video games. Saying you play them is almost the norm for a guy in America (and a lot of females too). But it's still considered really weird if you're a hard-core gamer. Not just someone with one game that they spend too much time on, but someone who owns almost every gaming system, and played hundreds of hours on hundreds of games? Still thought of as weird.
And some nerdy things haven't been main streamed (much or at all). TCGs such as Magic the Gathering, World of Warcraft, etc are all still viewed as very nerdy. Chess still falls into that category. Dungeons and Dragons does too.
(Just for the record, I do all of those (except chess) a lot...

)