The advocacy group NRDC has a much better explanation of the general concept and specific Mississippi/Ogallala proposal: https://www.nrdc.org/sites/default/files/Water-Pipelines-rep...
Two things become clear. The mississippi/ogallala project would have to be an aqueduct project and not a pipeline if it wants to move a helpful amount of water to justify itself and it would require an exorbitant amount of energy to pump water from, say, Omaha to Denver. It doesn't seem like it has a chance of happening before many smaller projects are attempted first local to the southwest.