Only one in six asexual people have had a universally positive experience of being out, new research has shown.