‘Deeply challenged’ Archbishop of Canterbury notes ‘stunning’ quality of many same-sex relationships