Yeah, that seems to have been an own goal by the Russians, given that they would probably still have that fresh water today if the dam wasn’t destroyed. We may never truly know why they chose to do that, but it lines up with the indiscriminate destruction as acts of terror they have used throughout the war, just at a larger scale.
The importance of the canal has diminished since the start of the war, and eventually they would have lost control of the dam entirely, so that would have been a factor.
The Russians have been known to sprinkle anti-personnel mines all through these areas. Seems not in this case, but for me personally I would be as sceptical as you are.