You're looking at Super Mario Kart, running on the Apple iPad, courtesy of emulation guru ZodTTD. When do you get to play it, faithful reader? Hard to tell. If, say, the iPad had already been jailbroken, all you'd need to do is wait for a suitably safe jailbreak method, download RockApp or Cydia, grab the snes4iphone emulator you see running above, and fire up the ROM. However, the intriguing thing about the above video is not that it's running an SNES game -- but that ZodTTD claims he compiled a special version of his snes4iphone emulator "specifically for non-jailbroken iDevices." Since Zod is almost certainly an official developer, it's possible he output the emulator as an .ipa file and is testing it on a fresh iPad using Apple developer tools, but if we're lucky, it could instead mean that someone has finally found a way to sideload apps onto a stock Apple device. Either way, peep multitouch karts sliding and shells flying on video, right after the break.
Update: ZodTTD tells us that while he does have access to the jailbreak, he did have to flex developer muscle (and official dev tools) to make snes4iphone work on a non-jailbroken iPad. He says:
The build of snes4iphone running on my iPad as seen in the video was actually based on an AppStore app I submitted called "snesty". Apple quickly rejected it right after pulling the NES emulator. I combined snesty with some snes4iphone features such as using the private API called CoreSurface. I used Apple developer tools and self signed it.
Zod says that after Apple officially releases iPhone OS 4.0 and the existing jailbreak is distributed freely, he plans to create new versions of his emulators that run at the iPad's 1024 x 768 native resolution and support touchscreen controls, hardware keyboards and even external controllers should they come.