They seem to have used a remote controlled modification of the FP-5 Flamingo cruise missile. These things are huge and awfully slow, and only around 20% of them actually reach their target because they are so easy to intercept, but they have a massive payload. Footage from the missile showed an complete absence of any active air defense - there are specific spots around the bridge that were specifically made for russian AA, but the missiles approach was completely unhindered. (Edit: it could mean that their analysis already came to the conclusion that the bridge cannot be saved). It impacted close to the already damaged spot (a tad above from the looks of it), which made the whole bridge part give out in an instant. They also damaged the railway bridge arc in the same attack wave.
The only remaining road connection to crimea from russia, going the long way along the coast, is well in range of the mid-strike campaign. When (not if) the railway bridge goes down, reinforcing crimea becomes an exercise in dodging a fuckton of drones on a very long road trip while burning a ton of fuel that is limited in supply these days.
Also, access to the Azov sea is now blocked by bridge rubble. These arches are not optional, they allow the crossing of cargo vessels.
Rebuilding this thing will be very much futile - i don't think Russia can develop a solution that is high-capacity, resistant against cruise missiles and allows ship traffic to go under.