Tom Scott has a great video[0] about a similar attempt to dam the San Francisco Bay that got a lot closer to actually happening. So see if it was practical, the US Army Corps of Engineering built a giant scale model of the SF bay and put a dam on it to see what would happen.