I think the reason people don’t really like the theme song very much is because it isn’t the classic instrumental. All of the other Star Treks have been very obviously Star Trek from the opening few tones. Enterprise isn’t like that.
Strange New Worlds got this, even though it was a brand new piece of music just the first few notes, you can tell it’s Star Trek without even looking at the screen.