The defeat of legislation introducing the first women bishops has been described as a “very grim day” by the incoming Archbishop of Canterbury.