If you don't like Majora's Mask, or the 3D Zelda titles in general, then this game probably isn't going to win you over. This doesn't take the place of an actual new Zelda title, but for those of us who enjoy the game it is a great filler until the next installment comes out.
As for top down vs 3d styles of play, that is pretty subjective. I am a Zelda fanatic, and I strongly prefer the 3D style over the top down (mostly because I prefer Zelda II over the original). That isn't to say that I don't like top down - LttP and Link Between Worlds are two of my favorite games ever. And to be honest, I kind of like how the hand held versions are mostly top down, while the console versions are 3D. Nice mixing and varying. Ocarina and MM are remakes of console versions, hence the 3D style on handhelds and an exception to the rule.
But I think the big reason for this remake is: Nintendo remade Ocarina for the 3DS...why not Majora as well? Took them a few years, but they listened.
...now if only Sony and Square-Enix would listen regarding FF VII....