A landmark UN assessment says decades of overuse have pushed critical water systems beyond the point where full recovery is realistic.