It's not a game that stands the test of time very well. Even now not even close to a decade since it's not really a game that is referenced/brought up all that often, and I get the sense it's not all the easy to revisit- you need a Wii or a Wii U along with the game and a Wii Remote Plus or a motion plus accessory. I don't think there are all that many people who have those things to hand- heck even the game is relatively rare, being a disappointment sales-wise, I don't see it at all often in second-hand stores or such. I find this is a standout thing about it now, especially considering the series' pedigree- most Zelda games are not like this, they can be played rather easily in a variety of ways.
As for the game itself? I like it a lot- certain aspects of it are a little overblown like the motion controls at least for swordplay and the linearity which is fine overall just not everyone's cup of tea. Certain other aspects- the interruptions, Fi, the lack of original content in the last third and the general stagnation of the series' formula are not so easily overlooked. The dungeons, visuals, music and puzzle solving are all ace.