No, it was very much created to destroy Sin. Bevelle knew it could destroy Zanarkand on its own.

The entirety of FFX-2 says that Vegnagun > Sin.

The fact of the matter is that Sin > Vegnagun, the Reich, Japan, 1945 America, and Psychotic.