Took a box of sparkling water and a Beretta A400 12-ga to the range today. Video below is 2 shots from around 25 yards.
And here's the outcome. The protected portion of the can only has some dents. You can see one of the pellets is embedded in the koozie (bottom right).
Run of the mill koozies didn't fare so well.