Well, I'm not sure if it's classified as truly rare, but yeah, it's rarer than the gray cartridge.
Funny that you should ask about this, because a few weeks ago when I went to the retro games store they have in my town, I saw that they had the gold, holographic cartridge of Majora's Mask you're asking about (and they even had it in the box, although it was opened).