The Sunday NY Times has this article about the parishes in Los Angeles and Atlanta that recently "left" the Episcopal Church over the homosexuality controversy.
[I]it appears most Episcopalians do not want to leave the church. A recent survey of congregations by the Episcopal Church Foundation showed about 60 percent "neither uncritically endorse or oppose" the decisions on homosexuality, said the Rev. William L. Sachs, director of research at the foundation. The foundation, an independent organization, follows grass-roots trends in the church.
About 15 percent to 20 percent of parishioners applaud the church's decisions on homosexuality, the Rev. Sachs said, and a slightly smaller percentage are affronted.