Bond, being Bond, is last to show his hand against this seemingly unbeatable situation ...
... revealing the five and seven of spades needed to give him a straight fucking flush for all the marbles. BOOM!
Here's the thing: The reason Bond's dramatic reveal is so, well, dramatic is that it's completely unexpected that a pair of low cards would actually win the game. It's statistically ludicrous that Bond won with what he had. And while it seems "smart" that he would surprise everyone like that, for anyone who knows how to play poker, the real reason it's shocking is because no idiot would hold on to those cards in the first place.
Here's a chart of the statistical likelihood of certain Texas Hold 'em hands winning a game -- 5/7 being on the very low side of probability compared to the other players' hands:
His cards suck balls, is the point.
And since Bond wasn't dealt his straight flush until after the pot was already at $24 million, it means that he had been betting big on a hand with insanely low odds of winning. When the blinds are $1 million, 5/7 isn't even worth playing with. Any normal player would have folded that hand before the flop.
Sure, Bond's cards worked this one time, but that was dumb luck. In the poker world, this is called a bad beat -- when a considerably stupider player stays in with a statistically impossible pair of cards and somehow manages to win against more skilled players. Bond isn't some amazing strategist, but rather the spy equivalent of some fanny-pack-wearing tourist blindly spinning a roulette wheel, randomly winning, and then attributing that win to skill. And for that, he deserves all the testicle beatings in the world.