Hi Julie, I’m not an Episcopalian and have never, at least not yet, set foot in an Episcopal church. So don’t necessarily hold me to any of this. I would love for an Episcopalian to come by and address your concerns better than I ever could.
But for just maybe a start to help in understanding I will offer some things I have heard/read.
I once heard Bishop Robinson sight the many other things in the Bible that Christians do not take literally.
And not necessarily by TEC but I also have seen Sodom explained more as a hospitality problem rather than so much as condemning homosexuality.
I have seen it written that we must remember English translations of Scripture did not come about for many many yrs and verses can take on meanings that were never intended. And what is natural to you or I might not be so for another.
I have also found the following helpful in my understanding.
religioustolerance.org/homconlib.htm
"Rather than concentrating on the seven “clobber” passages, they derive their beliefs from biblical themes of love, caring for other humans, inclusiveness, and justice. When they do study the “clobber” passages they often interpret them very differently and conclude that the Bible is silent on loving, committed consensual same-sex relationships. Typical interpretations are:
Genesis 19 discusses the city residents’ intent to rape strangers.
Leviticus 18:22 and 20:13 condemns same-sex behavior, but only in Pagan temples.
Various passages in Deuteronomy, Judges and Kings condemn prostitution.
1 Corinthians 6 condemns child molesters.
Romans 1 and describes heterosexuals going against their nature by engaging in same-sex behavior.
1 Timothy 1 contains thoughts similar to Romans 1.
Jude 1:7 accuses the men of Sodom of intent to commit bestiality: having forcible sex with a non-human species – angels in this case."
Another site which may provide understanding of this issue is
gaychurch.org/Gay_and_Christian_YES/gay_and_christian_yes.htm.
There’s a link about homosexuality and the Bible.
What I have presented is just a tip of the iceberg. But I hope at least a bit of this helps! God bless you in your lifelong journey and peace be with you.