I was not trying to offer a solution, as this will be highly specific to the situation in your locality and pretty pointless for me to spend time on. I am merely identifying this as a root cause, which for some reason strikes a nerve.

Why does Skoda, a car manufacturer, care so much about interactions between cyclists and pedestrians? As you say, a bell that penetrates the car enclosures would be much more useful. I suspect a similar reason why pro-safety helmet lobby groups in NL received a lot of funding from these same car manufacturers. I digress..

For your information, post-WWII infrastructure developments in NL were initially highly car-friendly. This only started to change in the 70s and 80s, when the government started to actually create bicycle-related traffic policy, after collective protests (e.g. popular pro-bicycle protest songs were written, children refused to go to schools unless bicycle paths were laid, etc.) also helped by the oil crisis of the time.

So, no it can't be fixed overnight, but it can be fixed in reasonable time (and not an unspecified amount of decades, political capital and funding). We are even living through a repeated history right now.