Well, I definitely feel like there many things (throwing, flapping, tightrope balancing, etc.), that don't need motions controls. But overall, it's a very good game and I'm enjoying it thus far. One odd thing, when I got MY copy (instead of playing my friend's), with the actual Wiimote+, instead of using the old MotionPlus attachment I had bought before, it worked a LOT better. Still not 100%, but it's much more responsive.
I think in general, Zelda is one type of game that I would prefer just pressing buttons for. Whereas Metroid Prime, FPS games, stuff like that, I absolutely prefer the Wiimote/Nunchuk setup. But Skyward Sword seems like a very good game so far, and I'm sure it'll only get better as I get further into it.