It does look great.I always thought it looked pretty for a Wii U game, though I haven't seen it on my screen yet.
Far from shit. But like many things it may vary from people to people; specially with different kinds of TV.
So ...someone playing on a 4K TV with all bells and whistles on; won't do the game any favors, since said bells and whistles degrade quality in cases like this.
More humble people with 10 years old 1080p Vizios like me, will find the visuals and overall look great. XD