An embarrassing picture yes. (Most likley there are some pictures floating around out there that would prohibit me from running for public office
)
But it really proves nothing. There is no way anyone could know what was in the water pipe and even if they were illegal drugs unless the powers that be (Olympic Committee) drug test him immediately he will pass.
I really don't see any Olympic implications for him.