
The stuff put into RAM was usually the graphics routines - the programming code that decided what pixels went where - and the cartridge was relied on to provide data when needed - a map's boundaries, object orientations and locations, etc. So the game designers had to carefully consider how to use the precious, but faster, ram on the console, vs the slower rom on the cartridge. RAM on the console itself is faster than memory on the cartridge (and the cartridge memory was usually read only, with a little non volatile for user data). The main point to understand is that the console is limited. Ideally, assume that I have at most basic knowledge about computers, roughly equivalent to a 101 textbook on computer circuitry and some programming experience, although explanations at any level are welcome. I'm not necessarily asking about this specific glitch, I'm just trying to get some kind of a reading on how it's possible for cartridge tilting to reliably produce symptoms like this. How could it possibly be that something as "brute force" as tilting the cartridge could reliably produce such a specific result without just making the whole game crash? This seems to me like dropping a typewriter down a flight of stairs and finding that it's typed out a novel. You can find videos on YouTube of this glitch happening to other people. These exact symptoms have been documented online.

This specific behavior can be reliably reproduced.

I mean, what, is there a special "rotate mario" pin in the cartridge?

I would have thought that tilting a cartridge would produce glitches more like "absolutely nothing works because everything's messed up, the game crashes", not "this specific 3d model will be rotated by precisely 90°". It's a very specific and subtle kind of behavior. What surprises me about this glitch is two things: Mario's limbs disappear, he rotates 90° and sinks into the floor, and the music gets messed up (usually it goes faster). When the N64 cartridge is tilted in Super Mario 64, it reliably produces glitches such as this.
