Lets first try to find source of leak. Take a look a photo below. Does leak appear to be coming from where the red arrow is pointed to (yellow highlighted area):
You need to have a cooling system pressure test to confirm leak, but I strongly suspect the water pump has failed.
Water pump is located on the left side of the engine compartment at the end of the engine block:
Without a cooling system pressure test being done, its almost impossible to verify source of leak unless it is obvious.
When the "engine overheating" light comes on, the "idle engine" and "turn AC off" lights will come on to instruct the driver to do these things in order to help cool engine off.
The "change engine oil" may have come on due to engine oil thinning because of engine overheating, it may have come on if headgasket is blown and coolant is in the oil, or it may have be a computer glitch.
The "service engine soon" light will come on when the engine overheats.
Anytime the engine overheats, especially on these Northstar engines, you have to be concerned about the headgaskets blowing. I have seen this many times on this engine.
The whirring noise is probably from the water pump or water pump belt breaking as a result of water pump going out. Or the belt broke and caused and the pump to go out- can happen both ways.
At this point, I dont advise driving it. It needs to be tested for source of leak, as well as a "block" test done to determine if combustion gases are present in coolant(blown headgasket).
Depending on source of leak, water pump can run $300 parts and labor, while a hose would be substantially less. Blown headgaskets will run over $1200 arts and labor-more if heads need machine work.
And yes, a severe coolant leak can cause an engine to shut down immediately to prevent further damage