While "Big Bang Theory" became a huge hit and folks loved it, "Super Nerds" bombed and wasn't approved for additional episodes beyond the pilot. Why? Both have strong similarities...but "Super Nerds" managed to create nerdy characters (in particular, Gayle) who you just cannot like. I think this is the key to why the show failed.
The program is set in a comic book store where Leslie (Patton Oswalt) works and Gayle (Brian Posehn) hangs out all the time. They are the stereotypical comic book nerds, though they are tough to like...particularly Gayle. As women come into the store, their ineptness with women is obvious. But when Gwen enters the place, Gayle does his best to drive her away when he learns that she is smitten with Leslie. And so the show ends.
I think had they re-written Gayle's character significantly, the show might have worked. Several times, he just seemed ultra-selfish and cruel. Leslie was easier to like but like Gayle was a bit too obviously written. Not a horrible show idea...but the writing really seemed to let the audience down.