I always took BBT to be nerds laughing at themselves. Yeah, the archetypes are a bit "on the nose" - but I wouldn't call it hostile to nerds any more than I would call Star Trek hostile to the races (real or fictional) or diversities it left out.
Don't read too much into sitcoms. They are little more than market-tested commercials with punch lines.