TLDR = Significantly more ram, somewhat more capable GPU, weaker CPU.
All in all I suspect it'd deliver similar overall performance to a PS3 but be massively easier to shoehorn the game into vs the PS3's 256mb+256mb XDR ram arrangement. In a dreamworld, SE would be allowed to leverage Tegra's hardware encode/decode for a gamestream style setup essentially offloading the work to a companion PC. I'd be utterly shocked if Nintendo allowed that tho =(