“Then disaster struck. I parked up and when I came back out I could see that someone had thrown a brick through the rear window of my car…”: John Fogerty on the making and meaning of rock’s jauntiest ode to the apocalypse