Close, but no cigar
Because it's running WIndows. You'll note from the vid that we only see the camera 'app' and the photo 'app' fully (and even those look like mocked up shots) We see a very cropped shot of iTunes demonstrating the use of Win7 gestures, but that's all.
There are some good arguments outlined above about why windows is 'better', e.g. you can install anything you want, it can run photoshop, etc, but these miss the point. If I want to run photoshop or a similar app, I will need a mouse, and preferably a keyboard. Touch devices are not suitable for running these apps, so the comparison is largely pointless. You want those apps, you need a different form factor.
Stacking up like for like, you need to consider only apps that are good to use on touchscreens, and even with it's much vaunted 'touch readiness' Win7 fails hard at these, because it's core UI doesn't cut it with fingers.
99.9% of windows apps are designed to be driven by pointing at things with a mouse and clicking on them, about the only ones that aren't are a paltry few 'show off' items from MS that don't actually work very well, and the ones supplied by the hardware OEM, many of which also fall into that category.
The touch software 'ecosystem' simply doesn't exist on Windows, sooner or later - no matter how many shiny manufacturer supplied apps they come with - using a windows touch screen device becomes a pain in the arse and you need a keyboard or a mouse to make it work, or you have to reach for a stylus to click the close box on a running application, or whatever. This puts it in the same position as the iPad vis a vis running 'serious' or 'creative' or whatever the hell you want to call them applications. E.g. you can't, unless you shlep round additional hardware.
So really, at this point in time, the Windows based tablets have even less utility than an iPad and will remain in the doldrums until MS come up with a decent touch screen interface. Either they fork windows, which is about as likely as Steve Jobs giving Steve Ballmer a reach around on you tube, or OEMs go with whatever they spunk out under the new 'Windows Phone' banner.
By then though, Android tablets will have been on the shelves for a long time. I'm a long time Windows dev, and own several touch screen devices and tablets running various flavours of windows, and I am not betting on MS for the touch based future, although I am betting on the touch based future.
It's coming, get used to it.