So when you think about it the show is primarily a sitcom. It's all very well getting your panties in a bunch because nerds are made fun of. But its a sitcom, name a sitcom where the male role isn't a goofy, inept, clown of a person. Name one where every single character doesn't have a foible thats made fun of.
Thats the bread and butter of sitcoms. You should probably just harden up, and not take it personally because you aren't really dealing with reality, and nobody sane takes TV characters as role models.