They Let Me Down. But Should I Really Be Surprised?

Paul and I have been watching the show Chuck on NBC since it started last year (which may have actually been this year, the way they do their seasons).
We have really enjoyed it. The premise is the main character - Chuck - unwittingly becomes the CIA's most valuable asset. An old college friend who works for the CIA, thinking he was going to be killed, sent Chuck the file with all the secrets - "the Intersect." Chuck views the file, and all the secrets become trapped in his head. The real Intersect is destroyed, so only place that these secrets reside are in Chuck's head until the CIA can build a new Intersect.
That sounds really confusing, but it's the base for the story involving this geeky Chuck who is part of the "Nerd Herd" at the local Buy More. Every episode he works with his two CIA protectors (one posing as his co-worker and the other as his girlfriend), trying to be smooth and savvy, but always messing things up, yet somehow always emerging victorious.
Several times before, they've had episodes where there was the opportunity to take things further than I like, with Chuck almost going to bed with his "girlfriend" (who he actually is in love with). But they always took the high road. But I guess they assume that since he's a nerd, it's expected that it's not going to be easy for him to "get some," so it's acceptable for him to not have sex.
But last night, his old college flame was back in the picture. And they slept together at the end of the episode. They glorified it with the orchestra music in the background, like we were supposed to be happy for him. But I was so disappointed. Because until this point, it had been a great show.... Very little, if any language, occasional social or special occasion drinking. He lives with his sister, who is living with her fiance, but they are not main characters - that part of their relationship wasn't glorified. Until last night.
I was just so happy for once that there was what I would consider a family-friendly show, where I wouldn't be ashamed to watch it with my children. Or my parents. Or my in-laws.
But really - what should we expect out of Hollywood. They are the ones pushing agendas. By making it appear to be "normal" for people in their shows to be sleeping around, using drugs, and having abortions, it de-sensitises our youth, and makes them feel as if it is normal, things they should be doing as well.
I hope that this was just a detour from the how they intend for the show to be. I hope they get rid of this new girl, because I really don't like her. (I have a soft spot for Sarah, the "cover" girlfriend.)
Then we can get back to the endearing, innocent Chuck.