When Adam first sees the woman in Genesis 2:23 and declares "bone of my bone, flesh of my flesh," the excitement isn't about sexual attraction. Adam's words simply don't translate that way.
It's about SAMENESS.
It's about seeing someone who is an equal. She is someone who can help Adam address the one thing that isn't good about all of creation: that Adam was alone.
The reason I mention the "not about sexual attraction" bit is because… quite literally, "Adam & Steve" DOES work here, because the text is pointing to loneliness.
If you don't understand this, I suspect you simply don't have friends. You don't understand that God gave us one another to address that woeful experience of being alone.
Human sexuality is a separate topic and a separate layer of experience. Friendship and recognizing sameness in others is a higher order of relationship.