Specifically, Billy Elish dragging-a-cat-by-the-tail inrto song.
It was beyond awful.
It was the worst 007 song ever!
The only thing that remained constant in regards to the traditional 007 female character is Moneypenny, she was on par!
The rest you've guessed correctly.
C'mon, it is a 007 movie, don't expect any laws of common sense to apply there!
It was a well-rounded culmination of the current era of 007 movies.