Vegnagun was not built to destroy Sin, only Zanarkand.

And Sin would beat the crap out of it anyway.