Majestic Red Dragon is not a "Rare" card in the Yu-Gi-Oh! TCG rarity hierarchy. It is classified as Super Rare (silver foil name + holographic artwork), which is the second-highest standard rarity:
Super Rares are more common than Ultra/Secret Rares but scarcer than Commons and Rares.