I think the bridge did its job, as designed, but a Bailey bridge was not designed for that level of abuse..
In this video clip, the bridge is seen being ripped off its mooring points and "floating away".
https://twitter.com/i/status/1571691855695290368
I suspect this one was installed using Bailey Boats(?) which added to the drag surface. It had little chance of survival.
ref: bailey bridge