I'm playing in right now, and after 25 hours I am already tired and bored, even if I only play it on weekends. If I played it every day, I'd have quit already.
And this has never happened to me with a zelda, ever. I was pretty annoyed with Phantom Hourglass between not having traditional controls and forcing me to go back to that temple with the timer. This one is similar but even worse.
It would need to be seriously remade, given an alternative non motion control method (Which will mean redoing al the boss fights), and fix most of the annoyances (Fi, resistance bar. And even like that it would be pretty depressing. Not to mention that it has garnered enough bad reputation to impact future sales.
In any case, zelda fans will never be happy. They are still asking for a literal Ocarina of Time 2 (3 if you count Mask of Majora). Nothing that you make will make them happy. Too cartoony, too mature, too repetitive, no traditional controls... It's bad enough when Darksiders was a better Zelda than Skyward Sword.