Short answer: Absolutely not. The Super Nintendo (SNES) and Nintendo 64 (N64) belong to completely different hardware generations with zero compatibility. Trying to force an N64 cartridge into an SNES is like trying to play a Blu-ray in a VHS player—it physically won't work, and even if it did, the consoles speak entirely different languages.
Bottom line: Enjoy N64 games on hardware actually designed for them. Your SNES deserves to play Super Metroid and Chrono Trigger—let it shine at what it does best.