I took my girlfriend and her cousin to see this movie, and they both really enjoyed it (they are not particularly into sci-fi). JJ Abrams has really opened up the world of Star Trek to the not-as-nerdy with this film, and at the same time, has kept it just as interesting to the already-established loyal Trek fan base.
Anyone that says otherwise is just bitter that Star Trek /can/ be cool.