The recent grounding of a large container ship in Baltimore's harbor channel demonstrates that a sufficiently massive berm will stop any ship. What's needed is the will to do something about low-probability but catastrophic events (though large-ship collisions, groundings and fortuitously harmless steering failures are frequent enough that this should not have been dismissed as a low-probability event.)
https://www.cnn.com/2022/03/16/business/evergreen-container-...
In this case, the nearby towers supporting transmission lines across the channel seem to be better-protected against ship collisions than the piers of the bridge.