Royal Exchange Theatre's chief executive Stephen Freeman has resigned following the cancellation of a production that referenced the Israel-Gaza conflict and transgender rights.