But note how the main bridge piers are on giant islands much larger than the pier itself: https://en.wikipedia.org/wiki/Dolphin_(structure)#/media/Fil...
If you really want to make it unblockable you build a bridge+tunnel. https://en.wikipedia.org/wiki/Bridge%E2%80%93tunnel
https://en.wikipedia.org/wiki/Chesapeake_Bay_Bridge–Tunnel
https://en.wikipedia.org/wiki/Chesapeake_Bay_Bridge–Tunnel