Madonna's song get some unnecessary hate... I really liked it at the time, it set the mood of the beginning of the film. Slightly different and more of a pop song of course.
I understand most of the older generation dislike it ( I know some younger fan dislike it as well!) or even the idea of madonna doing the song, but hell I think it wasn't too bad.
Madonna is 54 ... so she's one of the "older generation." That is, unless you're referring to someone in their 70's and I'd suggest that they don't post here enough for you to get an effective sample on.
Perspective does come with exploring films. There are new Bond fans that have only seen the latest Bond films and haven't yet explored the older catalog. This is as it should be as we all start from some point and move on from there, gaining perspective along the way. It's also natural for some fans to draw a special bond (no pun intended) to the films and music that made a impression on you when you're young. However, when a youngster loves an old theme song and a oldster loves a new song ... obviously those song have added traction.