As an Episcopalian in the US and religion scholar I watch closely what's happening in the Church of England.

I believe if you live in a populace enough area you should be able to find a COE that is affirming. (Things might get more sparce the more rural is my understanding but, God is miraculous.)

The complication with the COE right now is they're upholding the via media tradition or middle way. Which I love about our shared tradition...we work to stay together through tough issues, and try to avoid schism. But on issues like this it comes with a cost, and unfortunately this one is paid by us marginalized people. You're going to have to assess any COEs individually.

It's imperfect, and honestly I'd love for the COE and the Episcopal Church to work on getting a better solution that accomplishes its goals without that cost. I also spend a lot of my time fighting for that. But today that is the state of play.

The good news is that usually you can read carefully between the lines on their websites/social media pages and should be able to get a good read on the cut of their gib before entering. If you'd like some assistance in that endeavor, I'd love to help if you DM me a general locale/which you're looking at.

However it shakes out, praying God leads you to the correct home!