Paradoxically, the more Queen Elizabeth II revealed her religious convictions, the more the Church of England, of which she was Supreme Governor, was disaffected