No matter(1) the engineering there is no pretty much way to not lose the whole large middle area and left area leading to the destroyed pillar in that situation.
Such a collapse crates so much force (tension vibrations etc.) so that the collapse of the section right of the right pillar is not unreasonable.
The only question is if the impact should have made the pillar collapse.
But a loaded container ship is ... absurdly massive I mean they are like multiple high raise building (but not sky scrapers) standing squished together side by side. So the force it can apply is huge and if cargo moving in it there will be force applied to whatever it crashes into even after the initial impact.
And looking at the waves caused by impact with the base it was at least 8m high I think (depending on the container ship). So that wasn't a "slow moving" impact. And even slow moving impacts with container ships can tear apart a solid jetty.
So while the US has issues with infrastructure maintenance idk. if anything but building a many pillar bridge would have made any difference. And building a many pillar bridge might not be very viable depending on the under water landscape and water use under the main area.
EDIT: Looking at pictures with daylight where you can try to estimate the high of the ship using containers I would say the waves where handwavingly 4 containers high so ~9.5m and it also looks like the ship might have embedded half of the pillars fundament into/under itself (but it's a bit hard to tell to the angle of the picture). I think if that's the case probably the huge majority of bridge pillars of past and presence would have collapsed.