The show is about humanity taking it’s first steps into the wider galactic community, and the song is both about a journey but also less refined than other star trek intros, just like Starfleet is a less refined version of what we are used to.
I hated it until they changed it in season 2 or 3 and then I realized that I hated the new version even more and in retrospect the original wasn’t quite that bad.