Actually pmather is wrong. It makes a big difference whether any drink (including martini) is shaken or stirred.

In stirring, the drink is stirred with ice cubes for a few seconds, and the decanted. This causes only a slight mixing of the drink with the ice cubes, which means that the drink becomes cooler, but is not strongly diluted. Shaking, on the other hand, means shaking the drink vigorously in a shaker, so the drink gets diluted with a large amount of water.

James Bond is thus not an idiot, he is a wimp - he can't handle a strong drink.