I know a lot of people hate the song, but I like it. And not just the song, but the whole opening montage, which was a break from the tired old image of a stately starship zipping across the galaxy while overwrought orchestral music plays. Oh the majesty! The Enterprise credits did the very important task of using real images to show mankind's progression to the Star Trek era. It bridged the gap between the pre and post-warp drive eras. One thing that the Star Trek franchise never did the greatest job of was showing the connection between our present and the Star Trek future. Many times I have been annoyed at dialogue between characters where they talk about 20th century Earth like it's ancient Mesopotamia or something. It was only 400 years ago, sheesh! I read about the Renaissance, it doesn't feel that alien to me. So the opening credits tackle this and sure the light and breezy Bon Jovi-ish song isn't very Trekky, but it's upbeat and fits the mood of the show.
I think the montage is great. I just hate the song.
I think it would have been great to have a series of quotes about exploration to accompany the changing images. "One small step for man" and the like. Have it lead up to a shot of the Enterprise with Archer saying "Space the final frontier..."
My only real gripe with the opening credits is that it was to American focused.
First Satellite - Russian
First animal in space - Russian
First Man in space - Russian
First Woman in Sapce - Russian
First EVA - Russian
http://en.wikipedia.org/wiki/Soviet_space_program#Notable_firsts