Any advantage in regards to destroying the dam - would be solely to the Ukrainian side.Ukraine may have destroyed the dam. But, ironically, the reason of that is the opposite of 'escalation scenario'. On the contrary, it may be a way of drawing a frozen conflict scenario in some middle term perspective.
'Positive' outcome of the destroyed dam:
1. The Kinburn Spit. This piece of land was used by the Russians to control the Mykolaiv and Ochakiv waterways. Now, with this Spit virtually turning into the island and the Russian troops moving out of there, Ukraine could relieve these waterways.
2. Kherson. Widening the Dnieper riverbed in that area may ensure growing security for the city and diminishing the number of artillery strikes against it from the Russian side.
3. Making holding of the occupied parts of Kherson and Zaporizhzhia oblasts way more costly for Russia in a long perspective. Decreasing the level of the Kahovka reservoir can lead to an operational halt of Zaporizhzhia NPP, thus rendering the cheap energy won't be available for the occupied areas. This can also lead to numerous irrigation canals drying up with possible water shortages for agriculture sector.
All that would be unnecessary if Ukraine were to reclaim those territories in short term perspective.
It is of course all speculations now. It is unclear who really destroyed the dam and what consequences that will have.
Off course one can't out-rule that some overanxious Russian commander - pressed the trigger - if so he will be executed.
According to latest news and satellite pictures - it is now speculated by some "civil-engineer experts" - that the combination of lack of maintenance of the dam + previous Ukrainian HIMARS shelling of the dam - brought about it's 'crumbling" - 7-8 days before the dam collapsed - a bridge construction leading overhead of the three sluice gates had already collapsed. (Where the HIMARS had hit).
Environmental catastrophe experts were all amazed as to the speed and (ready emergency equipment) in place by both sides. - despite being in a war.