Sounds pretty gnarly. There are a couple possible lucky fixes - cracked flywheel, loose torque converter bolts, maybe something else, but that usually just creates a knock sound while the engine still runs well. Yours sounds pretty beat. Probably won't be that lucky. Side note, what fluid shot out of it when you started it?
