The partial destruction of the bridge might end up being better temporarily, it will allow the Russian sympathizers and quislings a chance to escape and makes winning the peace easier. I expect a lot of one-way rail passenger and road traffic out of Crimea as the rats run. When they drive to the sea of Azov to cut the land bridge, the Russians will have to stop them in a final battle. If they get to the coast, they can bring down the rest of the Kerch bridge and can attack a vital rail junctions in Metropol and northern Crimea with HIMARS. It also makes staying southwestern Ukraine difficult for the Russians with the possibility of being cut off there and in Crimea. They just need to cut the railways; the tanks travel long distances using them, wear out after a few hundred miles on the road and start throwing their tracks, railways also transport, fuel ammo and replacements.
It looks dire for the Russians as their options shrink and the Ukrainians expand with the shifting balance of forces and their quality. Soon the Russian could be down by 20 or 30 BTGs with tens of thousands of men and the Ukrainians will be getting enough Russian equipment to field several new battalions along with enough ammo to kill a lot of them. The balance of forces and their quality is shifting quickly with the Ukrainians gaining huge advantages in numbers of fighting forces, their quality and their effectiveness. They are also getting more western weapons too and that just adds to the weight of the forces they are pressing the Russians with.
Many organizations supporting the war are coming into fruition, like the massive expansion and creation of a drone air force, others are repurposing boats and yachts for crossing the Dnieper or are helping with preparing the troops for winter. Replacement troops are being trained in several countries and there are probably more replacements than loses lately with more in the pipeline, plus the Ukrainians are training new battalions inside Ukraine with plenty of retired outside expert help. Then there are the territorials and reservists who multiply the army's combat power.