Did the motor seize?
You might be OK. The hole is small enough that the engine vacuum probably kept most of the oil in while you were driving. If the oil light never came on that is a good sign. Once you parked it, the oil leaked out since there was no longer a vacuum in there. The awful noise you heard was probably just the lifters & timing chain rail banging around since there is no oil pressure to get them pumped up. As long as you only ran it briefly, you are fine.
This exact thing happened to me a couple years ago, & I fixed the oil pan with a hammer & some JB weld (eventually got a new one).