As a cradle Episcopalian, I have yet to meet an Episcopalian Clergyman who believes in Transubstantiation. Although,I have met a few who didn't believe in much of anything, unfortunatly.
There was one in a nearby Parish who went Catholic but he had been a "closet" Catholic for a long time anyway. I never met him personally however.
I intend to move over to the Reformed Episcopal Church myself. The Apostacy in my Church is more than I can stand.
Of course, it was a very High Church parish, and I am now a Catholic. I think it's the High Church-Puseyite-Oxford Movement-"Catholic Lite" folks who believe in the Real Presence, not the Low Church-Evangelical group within ECUSA.
I'm afraid ECUSA is doomed -- it was barely hanging together as a "big umbrella" sheltering a wide range of beliefs. GC 2003 just stretched the umbrella until it was irrevocably torn apart . . . and that exposed all these other differences that had been overlooked until now. The "High Churchers" like myself are going to wind up going over to Rome, or possibly Orthodox, unless there's an APCK parish near enough to attend. The "Low Churchers" have a lot more choices, including most of the continuing churches.