What makes a TV theme song great? For one thing, it has to be memorable for a lot of people. This gives an edge to TV shows that were hits before the age of cable, streaming, and a splintered audience, like the them from M*A*S*H or The Andy Griffith Show. I thought the theme from Northern Exposure was excellent, but the show isn't aired much anymore so people forget.
However, Rolling Stone didn't use that criteria for their list of the top 100 TV theme songs, so you will encounter plenty of entries you aren't at all familiar with. They used two factors: 1. how objectively good the song is on its own, and 2. how well it works with the show it's introducing. Number ten isn't even a real TV show, but there are still 100 songs because two themes were ranked at number two in a tie.
You can skip directly to the top ten here. -via reddit