Others on here are apparently familiar, but my understanding from the old days was basically that if the core is exposed (and not cooled by water) the fuel rods literally melt from the heat of the fission process. Once that begins, it is very difficult to stop, and the temperature is so hot that the melted core simply eats through the cement, steel, etc., below it.
When it hits the water table below the power plant, you get massive amounts of intense radiation steaming up out of the Earth, into the water supply, etc. Depending on what is below it, you could get some combination of radioactive gas or particles in the air, together with contamination of the area around the plant with varying degrees of intensity.
The criticism of these plants is that, no matter how many different things you plan for,no matter how intensely you account for them, over a 40 or 50 year period something is bound to go wrong or be extraordinarily catastrophic, breaching all of the fail safes somewhere along the way.