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?
Some covers:
Hackney Colliery Band: https://www.youtube.com/watch?v=LKHtfjXrUzs
Aphrodite (drum 'n bass): https://www.youtube.com/watch?v=20SezMmyE6w
Chet Faker (downtempo): https://www.youtube.com/watch?v=HIfFA8-RaHQ
Boeboe (trap): https://www.youtube.com/watch?v=0Qqw18evmVA
edit: This made me curious what comes up on a search for "radio 1 no diggity" - here's Backstreet Boys: https://www.youtube.com/watch?v=zg8vknZ9L0M
Ed Sheeran: https://www.youtube.com/watch?v=-uijKNxpRCQ
edit: it seems it only ever peaked at no.6 on the billboard top 100, even though it probably sold a lot more than some songs on this chart.