> But is it a separation of molecules? That is, would an object just rip apart into pieces?

It's this one.

Tidal forces stretch objects along the radial direction (toward and away from the gravitating body) and compress them along the other directions. Spaghettification is the result of tidal forces taken to the extreme.