If you are worried about this incident, just wait until you hear about crude-by-rail! Crude is transported through LOTS of residential neighborhoods and zoning doesn’t matter. Additionally, railroads are governed by federal law so states / local munis can’t put additional restrictions on where, when, or speed limits.
Is crude-by-rail worse for people than crude-by-pipeline?
Either way, our current methods of doing modern human things require crude oil to get from A to B eventually...somehow.
And the pathway this takes isn't necessarily one that is devoid of humans.
(I live in a small city that sees all kinds of rail fright, with many dozens of trains on any normal day. I'm very interested in your opinion.)