Eventually, on its own, computing may move out of the "nerd" area of interest and into the mainstream. It's already starting with smartphones, music players, and ever more intricate gaming consoles. Once that happens, computing will be cool, and some other area of interest will become nerdy. Or, computing will stay "nerdy", and maybe something else will become cool, like tabletop gaming or massive LEGO collections or comic books. (Sorry guys
Society will always need to label some as nerds, for whatever demented sociological reason there is for it.