Another North Sea safety disaster or environmental spill could lead to a massive public backlash against the oil and gas industry