The problem is that cattle consumes orders of magnitude more water compared to plants, on top of the fact that they also eat plants, of which they convert a small portion of into (edible) mass.
Their urine, en masse, is highly toxic to the local environment as it kills plants (high salt content, fertilizer burn) and pollutes rivers (pH, over-fertilization, algae blooming).