My wife is not interested really at all in science fiction, but she has been around me far too long to not have soaked up some of the fallout of my interest. She does love TBBT, though, I think even more than I do. We talked about this very thread yesterday, and she feels that the characters are not demeaned in the way that they are portrayed as 'science geeks' or 'nerds'. She really likes the characters, and not because she sees them as 'laughing stocks'. She enjoys the quirkiness, just as she (we) enjoy the quirky characters on other favorite shows that include M*A*S*H, Cheers, and Friends. [She also loves How I met Your Mother, BUT that program really annoys me... I can hardly sit and watch that sit-com, even if a Buffy alumna is in it!]
When we got married, I knew I was getting a groom's cake at the reception, but she surprised me in that she had the baker make a TARDIS cake. She kids me about Trek and I kid her about her obsession of watching the Green Bay Packers. What we see on TBBT resonates a bit with our own relationship.
It does make me sad to think that some folks feel that what we see on TBBT is somewhat of an attack on them and their interests. While I was never made to feel too badly about my own science & sci-fi interests, I know some people have been given quite a rough time about it, and that was -and is- not acceptable treatment. Most everyone I know is a big fan of some team or obsessed with some hobby.
Another point, I don't think folks working in the field of science and education like Stephen Hawking, Neil deGrasse Tyson, Ira Flatow, and Bill Nye would agree to appear on the program if they thought it was showing science types and science fiction fans in a bad light.