BERLIN—A leading German cardinal and confidante of Pope Francis, Cardinal Reinhard Marx, offered to resign as archbishop Friday over the Catholic Church’s mishandling of clergy sexual abuse cases, declaring in an extraordinary public gesture that the church had arrived at “a dead end.” The archdiocese of Munich and Freising published Marx’s resignation letter to the…