For me, Skyward Sword was a fantastic game. It definitely met all of the expectations that I had for it, which is saying a lot considering how high they were. The motion controls are practically flawless, and most people have few issues. Most of the issues that occur are simply user error instead of actual flaws with the motion controls themselves.
Like RP said, it's not quite 50/50. Most people like Skyward Sword, and think of it as a great game. Many people just have a lot of negative things to say, but they still like the game. Few people legitimitely hate Skyward Sword. It's just that, for many people, it didn't live up to their expectations. The people who dislike Skyward Sword tend to be more vocal. I know a guy who constantly talks about how many flaws Skyward Sword had, yet he's currently on his 4th playthrough. For the most part, the Zelda community still likes the game.
Also, don't let other people talk you out or change your opinions. If it looks good to you, get it. If I only listened to reviews and other peoples opinions, I never would have bought Resident Evil 6 or Final Fantasy XIII, both of which I ended up loving .It does have quite a bit of flaws, but most of them are minor, and pale in comparison to the sheer amount of things Skyward Sword improves on and does right.