Kind of tried to tie the star trek vision of common endeavor to the NASA age of common endeavor. The one we sold off to Elon Musk and Jeff Bezos.
The viewers largely didn't, and now Trek is very pretty to look at, and even arguably more of a fun ride, but doesn't lean into conveying the message of human aspiration and cooperation as it once had. That kind of ended with Enterprise, and I miss that.
I wonder if they had gone with an instrumental version instead it would have been accepted much better. The visuals are totally Star Trek and exploration/innovation. Not exactly classical music, but it was having lyrics/established song from a popular singer that hit the wrong way. Ironic that the TOS theme had lyrics as well, although I don't think any episode that I recall ever played that version.
I actually like it too! Though it does get stuck in your head! I agree, I like the concept of the opening sequence portraying human advancement and the desire to explore, facilitated by cooperation. (I thought SNW did a good job of capturing that feeling, among the new treks.)