Trying to demolish a capital structure like a bridge with rockets would be incredibly wasteful, they’re better spent for precision strikes on ammo depots, airports, vehicle storage, etc. The payload of the long-range ATACMS is only 214kg, somewhat on par with the FAB-500 bomb, which carries around 200kg with stated TNT equivalent of about 300kg. The truck explosion on that bridge last year was estimated at around 10 tons TNT equivalent, it barely shifted a couple slabs, and was fixed within weeks.
Using sea drones to take out supports might be a better idea, they’re at least considerably cheaper.
I think it’s a Ukrainian RK-3 “Corsair” ATGM. You can see the RK-3K marking there, suggesting it’s a tandem-charge HEAT warhead. I’m guessing the first one malfunctioned and didn’t launch, but was probably already primed for it?