The crazy thing is it isn’t even the bridge being shoddy. It’s terrifyingly simple physics. High mass objects moving slowly and low mass objects moving quickly are both incredibly destructive. I’m not entirely sure how you build safeguards against a collision like that. It would need military grade protection – assuming even the military has something which could withstand that.
Think of it like this. A bridge is designed to distribute weight and force and stand up. It isn’t designed to take a hit like this.