This sort of treatment costs so little to install, just a few thousand euros and political will. And the tragedy is that most towns could easily come up with the former but can't muster the latter.
I definitely prefer bollards since drunk people can barrel their truck through this style of gate but bollards... bollards are going to stop that shit.
I'm concerned that that entrance is uncomfortably narrow for a bike. Or even for two pedestrians walking side-by-side.
My city has recently been removing its banana bars at the entrance to pedestrian and shared paths, and honestly it's so much better. You don't need to be as narrow as this to keep cars out.