Most of the top supercomputers are used to model nuclear weapons, weather and climate, and various sciencey things.

I don't know if the top ones are still used for oil and gas exploration (crunching data to provide higher resolution and higher accuracy oil field maps), but they have been in the past.