This makes a lot more sense to me as to the origin of the Great Lakes, opposed to the common explanation that the extremely sharp and deep lakes were carved by glaciers, which one would expect to be very shallow instead

I think the formation of the Lakes by glaciers was substantially different to glacial action we see today. It's commonly accepted that the Lakes were formed by the existence of the Laurentide ice sheet which was up to _2 miles_ thick in places - that's vastly different to the glaciers we see today and the effects that they have had.

While the idea that they filled up from below may make more intuitive sense at face value, the "common explanation" in this instance is substantiated in many different ways and doesn't seem far fetched when you study it a little further.