The song you're talking about is the 007 Theme.
I couldn't find an explicit answer but I would say it has to do with John Glen taking over as director. He changed the direction of Bond movies away from a upbeat camp action style (like the old Batman series) towards a more serious drama. The comedy factor which this track embodied was dialed down. As part of
that change, Bill Conti was brought in as composer and the 007 theme was out.
As for it's last use in film this is from the Wikipedia page:
"007 Theme", not to be confused with the "James Bond Theme", is an adventure theme composed by John Barry in 1963 for the Bond film, From Russia with Love.......
It became a secondary theme for the Bond films, being used throughout the series, primarily during action scenes. Here are its most notable appearances:
- From Russia with Love — Played during the gypsy camp gunfight and also during Bond's theft of the Lektor decoder from the Russian embassy in Istanbul.
- Thunderball — Featured briefly in a climactic underwater fight and featuring on the film soundtrack album; a similar but different theme of seven beats is played when Bond runs from SPECTRE during a parade and during the climax.
- You Only Live Twice — Played during the flight of "Little Nellie" before Bond battles four helicopters that attack him.
- Diamonds Are Forever — Played during Bond's destruction of Blofeld's Headquarters.
- Moonraker — Played during the Amazon River chase.
The theme has not been featured in its entirety in a Bond film since its use in Moonraker.
If you're looking for it on Spotify, it's called
007 by John Barry (The Music of John Barry).
And the final time it was featured in a Bond movie, Moonraker it was called
Bond Arrives in Rio and Boat Chase by John Barry (Moonraker).