Good for the older Zelda fans. Like, 12+. Mainly because it's just not as appealing to younger fans.
This game was pretty good, but not super good. Ocarina was much better. My only concern is that the game is actually pretty creepy compared to Ocarina of Time. A slightly disturbing transformation video takes place each time you put on a mask that makes Link transform into a different type of character. Also, Majora is sadistic and all that. As for the Great Fairy, the graphics are so horrible it really is not an issue. Also, most kids may find that the fact they have a limited time to beat the game will be incredibly frustrating. You have to save the world from a moon crashing into the town (which is happening because of Majora). If you let the moon crash before going back in time (which also resets everything that happened in the world except for stuff you unlocked in temples. You also lose all your item and money stock), you have to start ALL OVER. Like, your game file is completely reset (correct me if I'm wrong. That happened to me when I did that.)
But yeah, Ocarina is a much better choice than this. Even at 14, when I got it, I found it frustrating. It took me on and off 2 years to beat it. Ocarina took me almost 3 whole days, and it was a lot more fun. In short, the game is fine. It's just hard and frustrating for most younger kids who would like Zelda (almost exclusively because of the time limit, which is about 3 hours).