There is a recognition and growing acceptance within wider society that human sexuality is not one-dimensional, writes TP O’Mahony