My first real exposure to Skyward Sword was watching Johnathon Holmes (whom I cannot stand) of Destructoid play it at E3. It turned me off the game completely. I lost every bit of interest then and there. Zelda is my favorite Nintendo franchise by far and it was probably the pivotal game for me in terms of wanting a Wii, so it was really like closing the book on the entire console. I didn't think about buying a Wii again until the Operation Rainfall games were released.
Personally, I don't even consider it a Zelda game. It's a Wii game with a Zelda shell, wrapped around a Harry Potter center. Even if I end up buying a Wii U for the RPGs (and maybe the next Zelda) I doubt I'll even give a moment's thought to Skyward Sword. It's just not what I'm looking for.