Sadly, there's not much that can be done to fix humans.
The elevenfooteight bridge now has a traffic light which goes red and stays red on detecting an overheight vehicle, with a lit-up sign saying "OVERHEIGHT MUST TURN". It's still getting hit by overheight vehicles.
And then there's the lengths that had to be gone to in Syndey to stop overheight vehicles entering tunnels:
The 11'8 bridge does indeed seem a lost cause as far as preventing people from ruining their overheight vehicles. But the problem for the bridge has been solved: they installed a beam in front of the bridge which takes the impact.
The same sort of thing could be done with this bridge. Install a sturdy beam ahead of the structural bits. You won't stop people from driving overheight vehicles onto the bridge, but you will stop them from destroying the bridge in the process.
You could have sacrificial beams in front of all the important ones throughout the bridge, if you're worried about lane changes. That may not be worthwhile though.
Right, so you'd need a lot of sacrificial beams if you wanted to defend against lane changes in the middle of the bridge. Probably easier to add structural redundancy instead.
The water is right at the tunnel entrance, not in the area where you would be braking to avoid impact. By the time you've reached the water you will have collided with the top of the tunnel, which should go a long way towards helping you slow down. Literally 'idiot proof' design right there.
The elevenfooteight bridge now has a traffic light which goes red and stays red on detecting an overheight vehicle, with a lit-up sign saying "OVERHEIGHT MUST TURN". It's still getting hit by overheight vehicles.
And then there's the lengths that had to be gone to in Syndey to stop overheight vehicles entering tunnels:
https://www.youtube.com/watch?v=NoTMC-uxJoo