Is the job of the devil's advocate to create destructive conflict?

No, the job of the devil's advocate is to present alternative viewpoints and challenge prevailing ideas in order to stimulate critical thinking and thorough examination of the issue at hand. The role is to ensure that all perspectives are considered, not to create destructive conflict.