A spy's main job is intelligence gathering, not blowing stuff up and killing people. Read a memoir of a retired CIA officer and you will quickly understand that Bond doesn't resemble a spy in the slightest. Don't get me wrong, I still find the movies entertaining. I consider them action movies, not spy movies.
Tinker Tailor Soldier Spy I think is a better depiction.
For example, you would never have a fictional top notch surgeon, who picked his nose during the surgery. Everyone understands that you just don’t do that.
Yet you have a spy who violates most of the spy craft guidelines. I guess that is a commentary about how far off society’s perceptions are of what a spy is.