Well, you'd be surprised. Even if the majority cared about "tech startup founder-programmers" (which remains to be proven), it would be for the money and prestige involved, not the nerd factor. It's just this decades version of the Gold Rush, not some cultural shift.
As for comic books and Reddit, those are, as you say "completely mainstream", so they are not a differentiating factor between nerd and not nerd anymore. (Plus, the former are mostly mainstream due to Hollywood -- sales of comics have not really skyrocketed, and even events like Comic-Con are 80% Hollywood and TV these days).
Plus, nerds are not just startup founding hackers. Millions of programming nerds will never start their own startup. And there are tons of other kinds of nerds besides: book nerds, chemistry nerds, physics nerds, etc. And I can assure you they are as far from "rock stars and professional athletes" as ever.
And that's just for society in general. In high school it's same as ever, and one's ambition to "create the next Facebook" does not make him popular or get him laid at all.