I think it’s because it’s so different from any of the other Star Trek themes, even from the rest of the Berman era. It’s bright, bouncy, optimistic, and bombastic. DS9 and Voyager were both more sweeping and majestic, and the movie themes each skewed more melodic.
The franchise hasn’t really captured the same energy in a theme since, either.