It is easily one of the best Zelda ever, having a high quality story, having an extremely innovative gimmick and essentially good musics.
Nowadays, games such as Zelda Twillight princess/Skyward sword, Dark souls, horizon and such are effectively better than Ocarina of Time, but nonetheless it deserves its fame.
Don't be stuck with this game because there are Zelda games waiting for you, it may be an excellent game, but other Tloz are great too.
The unique flaw with this game is that progression is kinda slow, but in the end it extends the gameplay time making it long enough whilst some Mario games are incredibly slow.