CNN — When torrential rainfall in August 2022 pushed the Pearl River in Mississippi to surge well beyond its banks, floodwaters spilled into the suburbs of Jackson and led an already-hobbled water treatment plant to fail. It was the final stroke in what experts described as a yearslong issue in the …