I think you are underestimating how tough it would be to be playing James Bond and not tell anyone.

You wouldn't have to be a delusional braggart to want to tell a friend this. Most spies are not going to be as much of a compartmentalized lunatic like Robert Hanssen or someone at that level.