The vacuum itself wouldn't freeze anything, as previously stated, but the rapid depressurization sure would. Like a giant can of compressed air you use for your computer. The opposite is also true. Sailors on submarines that suffer a catastrophic hull breach are actually flash-fried by the compression of air by the incoming water rather than drown.
No. Seriously, just no. Yes, compressed air cools when it expands, but you're forgetting two things:
1) The air isn't nearly as compressed as that inside a spray can. It starts out at normal pressure and then gets thinner. There'd be a reduction of only 1 atm of pressure, which would have a cooling effect but not a deep-freeze effect.
2) The reason explosive decompression is called that is because it's almost instantaneous. It's not the prolonged gust of wind seen in movies and TV, but a single sudden burst. The air molecules would be rushing past the body so quickly that they wouldn't be in contact with it long enough for any substantial heat transfer to occur. It would be cooling like any strong wind, but only for a second. To say it would instantly freeze the body into a corpsicle is just plain silly. At worst, it might chill the skin; the interior of the body wouldn't lose any significant amount of heat in the process. And any chilling effect would end almost instantaneously.
The difference from the flash-frying is that in that case, you're getting more air forced into contact with the body, and that increases the efficiency of the conductive/convective heat transfer as well as increasing the temperature of the air. But if the atmosphere goes away, then so does the conduction and convection, and so heat transfer (in either direction) becomes less efficient.
Here's (an unfortunately crappy) Youtube video of the scene. The guy gets in a spacesuit, welds a hole into the door, and then blasts the other door. And then the air flowing through that tiny hole rips the entire door out.
Okay, I don't see the point of drilling the small hole. Like I said, if you've got atmosphere on one side of the door and vacuum on the other, you've already got the maximum pressure differential you're going to get.
I suppose the analogy was to putting a pinprick in a balloon or a tire, or shooting a compressed-gas tank with a bullet -- damage the structural integrity and the whole pressure vessel fails. The problem is that it fails from the point of structural compromise. This showed a hole drilled in the middle of the door and then the whole door ripping off at the hinges. That makes no sense. If the structure were going to fail, it would fail at the point of damage, ripping open from the hole. The whole door ripping off might've made sense if the sabotage had been to the hinges, if they'd been weakened enough that they'd fail under the pressure once the outer door was blown. But given what was shown, probably all that would've happened was that the air would rush out through the hole and the door would stay on its hinges, with maybe the hole getting forced a bit wider.
(On reflection, maybe the idea was that the hole in the door caused it to warp outward or something, thus weakening the hinges and causing them to fail. But that's a reach, I think.)