https://www.epa.gov/cleanwaterrule/what-clean-water-rule-doeshttps://en.wikipedia.org/wiki/Clean_Water_Acthttps://www.google.com/search?sourceid=chrome-psyapi2&ion=1&espv=2&ie=UTF-8&q=navigable%20waters&oq=navigable%20water&aqs=chrome.0.0j69i57j0l4.1994j0j7I'm linking these to help everyone understand the situation a little more. This executive order doesn't repeal the
Clean Water ACT, just a specific rule among the act that defines what geographical waterways are protected by the act itself.
After careful reading of the the
Clean Water Rule and the effects of the executive order, the repeal affects navigable waterways and their tributaries, nearby waters considerably close to the main waterway being affected. It affects the protection of prairie potholes, Carolina and Delmarva bays, Pocosins, and Vernal Pools. Affects protection of streams (and specific types of ditches.) Maintains status of your storm runoff water (which is most likely heavily polluted.) Affects the limitation water brown townysis.
Almost all of the above geographical waterways/sources were protected under the Clean Water Rule, but because of the repeal, they are free game for the dumping of pollution (within reasonable margin.) However any pollution can seriously harm the environment. This will hurt farmers, ecosystems, and ultimately the economy. If some of these bodies of water were to be polluted such as a prairie pothole, you could see massively reduced crop yields, dead wildlife, and poor game hunting.
Tributaries and their waterways will still be protected by the Clean Water Act, but the rest is no longer protected thanks to the rule only specifying them as being protected.
We're not going to see Flint like conditions in the United States, as this does not affect how our water is treated and how it's transported. However, we're going to have a lot of unhappy farmers and hunters. Ultimately this executive order is dangerous for our nation in the long run, the affects won't be felt immediately. In two years, I expect crop yields of the US to drop significantly, so much so you can see certain fresh vegetation and grain prices skyrocket in your store. Examples would be plenty of grains such as rice, barley, wheat and vegetables such as corn, beats, and carrots.
Pictures of some of the geographical formations I talked about


Prairie potholes. Notice the first picture, it is just a meter away from farmland.


Pocosins


Vernal pools

Carolina Bays.