Hardly something that will happen in a few thousand years. But you never know.
The Detroit river, lake StClair, and the StClair river beg to differ. In particular, StClair has a channel cut through it for shipping to be possible as much of it is less than 10 feet deep. Flow would increase, but I think they'd maybe add a dam and lock somewhere to stop it. But Niagara is a long way from that point, especially since diversion for power has dramatically slowed the erosion.
This is old, but it's also possible that niagara falls just stops being falls and stops moving upstream: https://pubs.geoscienceworld.org/gsa/gsabulletin/article-abs...
So Niagara is slowly eroding and will eventually reach a tipping point where further erosion will increase the rate of outflow from Erie. The increased outflow will increase the rate of erosion which will increase the rate of outflow, and so on. Correct?
When this is happening, the rate of outflow from Michigan/Huron via Detroit and St Claire will increase, but erosion is not necessary for this to occur?
Say we built a dam on the Detroit River that keeps Michigan/Huron at its current water level. And then Erie turns into a river. Once that transition is complete, we destroy the dam. How much time is necessary for Michigan/Huron to drain? Is the timescale days, weeks, months, years, etc?
Imagine what it was like here when the ice sheets first retreated. Niagara falls but times 100.
[0] https://www.lre.usace.army.mil/Missions/Great-Lakes-Informat...
(Like just as a gut check, much of the border of Wisconsin and Minnesota is a tributary of the Mississippi River)
The Great Lakes only exist because the massive ice sheet melted and left the lakes as a deposit some 10-15,000 years ago.
I wouldn’t be surprised if in a few thousand years the lakes largely dissipate.
That said I grew up near the lake, definitely something that’s awesome to live near