'End of the world storm' as apocalyptic weather batters city in scenes 'like a disaster film'