what CSI does it add information that wasn't initially there whereas what this is doing is just unscrambling the information. This is only for photos where the camera has moved during exposure, so should be great for low light shots (indoors etc) where you need a shutter speed a bit slower than optimal, say 1/5 second
Yes. This achieves the maximum possible theoretical resolution of an imaging system. The CSI-ish "enhance" feature typically goes well beyond the maximum possible resolution of an image.
I assume this just undoes the effects of an unsteady camera during exposure--all the information is present in the image, just smeared along a predictable path, and can be reversed by something akin to a deconvolution (but more complicated as it involves arbitrary nearby points).
Upscaling an intrinsically low-resolution image is still in the realm of creating information where there was none, I think.
This is seriously cool technology.