It would work - in theory.
I don't doubt that lots of machina could've destroyed Sin, but it'd take *lots* of machina, and this only to destroy Sin's barrier.
And then they'd have to deal with the undead city as well.

...but it is theoretically possible; they just have to use enough machina.