And I don't care if the guy is writing Bond books. He's no Ian Fleming.
007 is practically his own genre, and genres have expectations and rules. Leave James Bond alone! Let him drink, smoke, brawl, and flirt as much as he pleases as long as he's also sparring with Moneypenny and Q and M and going after bad guys.
Gee, next we'll see some awful wussified version of Bond who is a pacifist vegan hipster or something! No, thanks. I leave you with classic vintage Bond: women want him and men want to be him. It's movie magic.