I liked it well enough. The pros for me were as such:
Great art style
The new Zelda style and personality were great
The plot was pretty well done, with some great characters like Groose
I actually liked the silent realms. Very tense at times, in a good way.
The dungeons were (typically of a Zelda game) all pretty well done.
The boss fights were particularly good if I recall correctly.
I like the hub world and centralized shops of Skyloft.
The music was great as usual.
The motion controls were hit and miss. Some of the boss sword-fights were great but it still suffers from poor detection and responsiveness often, like all Wii games.
Cons include
The flying is pretty weak. Compared to Wind Waker, there are extremely few actual islands or places of note to visit.
As noted above, there are pretty much three main areas that are introduced, which you then retread for the rest of the game.
The latter half of the game is filled with a lot of fetch quest/filler content.
Fi. In addition to being a fairly cliche and archetypical "robot who doesn't understand emotions beep boop calculations percentages blah blah", she's extremely annoying. Sometimes while in the middle of solving a puzzle, she'd pop up essentially just to tell me how to solve it. She also chimes in when your hearts are low, as if I can't clearly see that, when the Wii's batteries are low, which is pointless, and when your shield is about to break, even though there's a clear HUD element for just that reason.
Also for some idiotic reason, you will often end up seeing the description of small collectible over and over and over again. Because why not.
Overall it was alright. Not extremely good or bad. A decent addition to the Zelda franchise.