Drinking was part of his character in You only live twice he was knocking down the saki and proud of his intake.
Yes, I have no problem with that. But YOLT was the penultimate novel after OHMSS, after the death of Bond’s wife. Bond was generally depressed because of it but tried to move on.
It was also written near the time of Fleming’s death when his spirits and health were in decline. Some of it due to the Thunderball lawsuit. The novel was published only 5 months before Fleming died.