The Church of England has "turned a corner" after its ruling body voted overwhelming in favour of welcoming transgender people, the vicar who brought the motion said.