By turning the death of Newcastle’s shipyards into a stage musical, the former Police frontman abandons pop certainty for the rituals of collective memory.