Everytime a console is revealed, we always get tech demos showcasing the console's potential. Key being potential, because said tech demos are always just pre-rendered videos, which of course always look better than anything real time, even if it's in engine. Wii-U might get something close, maybe even from Zelda U, but I doubt anything on Wii-U will ever look that good.
That being said, I really wish they had stuck with the darker Zelda style from that footage. I still can't get on board with the brighter more colorful style.