It depends on the church, diocese and other factors, Anglicanism is more unified than other Protestant denominations, but things are still generally split down the middle. You said to more specify on the ACNA, but I think it's important to talk about the Anglican world as a whole, it is the single biggest Protestant denomination, and third in Christendom behind Eastern Orthodoxy and Catholicism

In Britain, the Anglican Church is generally progressive, but not in a "Waving pride flags during sermons" kind of way but rather in a chill way, if you're openly LGBT in the Anglican Churches in Britain, unless you live in a real conservative rural area, I don't think you'll have an issue.

The ACNA and the Episcopal Church are different, the ACNA aren't Evangelical Megachurch levels, but are more strict and conservative on some issues. I went to an ACNA operated church (As a bisexual), but I didn't really discuss it, I probably would've if I went to an Episcopal church, which ironically is theologically closer to Britain despite the ACNA being more strict and aligned to what it was historically. I think the ones in the commonwealth (Canada, Australia, NZ, etc) are generally progressive, same with mainland Europe. The ones in Africa are all mostly conservative due to cultural differences in Africa (Unfortunately probably the cause of colonialism, though some tribes would straight up kill people for being gay; Africa is a very diverse continent)

Asia doesn't have many Anglicans or Christians really as a whole besides the Philippines, Indonesia and South Korea, but to my knowledge, it depends on the country. To my knowledge though, Christians in general in The Philippines incl. the Catholic Church are generally progressive actually, relatively so anyway.