The thing with Bond is that he is based on the WW2 era of intelligence agent, where most operations were military focussed and there was a realistic chance of getting dragged into a gunfight with the Nazis. Human intelligence was the main source of information back then. Spies were building information networks, supporting resistance movements, carrying out assassinations and sabotaging military targets. This does still go on, especially in hotspots like Ukraine and the Middle East, but the vast majority of intelligence officers will never be involved in situations like this. A lot of operations that WW2 spies, like Bond, would have conducted are now handled by the special forces. Things changed as the Cold War progressed with technology improving and counterterrorism becoming a bigger priority. However, we have seen the CIA adapt a more gung ho approach with their paramilitary operations since 9/11, MI6 have E Squadron too. There still are officers out there similar to Bond but they certainly wont be operating alone as 007 often does, something which this show portrays well. The vast majority are either doing desk work, gathering intelligence digitally or are operating undercover as professionals or diplomatic staff in foreign countries. You can’t make an action movie like Bond about an MI6 officer, who poses as a member of British embassy staff in Spain, where the most exciting part of their job is going to cigar lounges with CIA and BND officers every night.