In taking down a mediocre, semi-pornographic Victorian painting, Manchester Art Gallery invited public responses to a question that some critics do not want asked, says writer and curator Gilane Tawadros