It seems a fair proportion of the big movies of the 80’s and 90’s had blockbuster songs associated with them - either by a big name band or solo artist (or sometimes a duet)
I’m thinking of things like “Robin Hood : Prince of Thieves” with “Everything I do (I do it for you” by Bryan Adams", and “The Three Musketeers” with “All for Love” by Rod Stewart, Sting and Adams (again).
The last movie that I can remember having the “big song” was Armageddon, in 1998, with “I don’t want to miss a thing” by Aerosmith.
After that, I don’t really remember there being another movie that had a big hit associated with it.
Now granted, most of the songs were crap, and the whole idea would probably be seen as naff now - but was “Armageddon”/“I don’t want to miss a thing” the last version of this phenomenon, or just the last successful version.
I seem to remember a lot of the early 2000’s superhero movies (like Spiderman) have various big rock songs with them. I think the waning popularity of the music video did them in. They would always have some giant video featuring scenes from the movie. Now it’s just “this song plays during the credits.”
Iron & Wine’s “Such Great Heights” was included on the Garden State soundtrack in 2004. Maybe not “I Don’t Want to Miss A Thing” levels of popularity, but it was a tremendous hit.
I’m surprised the last few James Bond movies didn’t produce any monster hit singles. Napoleon Dynamite had that White Stripes song, but it wouldn’t fill up a stadium.
The Transformers movie from last year had that Linkin Park song. (I’m being really specific here, no?) I don’t know how much mainstream airplay that song got, but it was on the rock station I listen to all the freaking time for a couple of months.
2012 tried to go that route - it had a big anthem sung by Adam Lambert straight off his American Idol run. I don’t know how successful that was, though, as I’ve never seen the movie or heard the song, that I know of.
ETA: Apparently the Transformers movie I’m thinking of was the second one, from 2009.
It wasn’t something you were likely to hear on Top 40 radio, but I seem to recall it got a lot of play on CMT and country music stations back in 2000 and 2001.