I think there's a lot of overlap on what people like, but the Zelda series is sorta split into 2 audiences.
The series has some good "core gamer" targeted ARPGs, like the OG NES Zelda, A Link to the Past, and Twilight Princess.... but it also has some stuff clearly made for... younger casual players, such as Wind Waker, Minish Cap, Spirit Tracks, and so on. There's a lot of overlap between the groups, where you might have a Wind Waker fan who loves Ocarina of Time, or someone who likes both Minish Cap and Majora's Mask... but I still think it's rare that someone loves every Zelda game.
It's my opinion that Skyward Sword didn't go over well with the "core gamer" Zelda fans. It's reception was a bit better with the "casual" fans. And, given that this is a forum that would tend to attract more "core gamer" types, it doesn't surprise me that Twilight Princess is wining 8 to 1 in the poll.
I personally hate the game. With how many times NPCs reminded Link that he had been friends with Zelda since childhood, its like Link must have suffered some kind of horrible brain injury where he might suddenly forget who Zelda is and be like "WHERE AM I WHO ARE YOU VILE WOMAN ON BIRD THING OMG HELP AAAAAAAH!" and maybe attack her, if they don't constantly remind him about who people and things are in relation to himself. "This is your friend Zelda, Link, you've been friends with her for a very long time, everything is OK".
Anyway, that was a weird tangent. Uh.... Game forces motion controls down your throat. No other control options. Therefore it sucks. Other reasons why it sucks, but that's enough.