‘The place lost its way. Now that’s changed’: can a Manchester art museum move beyond its troubled past?