There's also plenty on the list that I recognise but I can guess why they've faded. Most obvious are followup singles that charted well despite being pretty bland (it was some previous song by the artist that was good). There's also a couple movie tie-ins that were only popular alongside the movie. Some, like Bryan Adams' "All for Love", manage to tick both those boxes (I don't think I'd heard that song in 25 years).
And Winds of Change by the Scorpions was gigantic in Europe in the early 1990s but it is literally a song about perestroika. It's about as entrenched in a specific era as a song can get.
Edit: wow, same website has an article discussing why "No Diggity" is the most timeless song. Shows what I know?