When the water vapor condensed, a vacuum was created in the can and the weight of the atmosphere crushed it.

(Note, the weight of the atmosphere crushed the can before the water could fill the can through the small hole in the top.)

Atmospheric pressure is about 14 lbs per square inch at sea level.