Can Metal Gear Solid 2 substance work on Xbox 360

No. At least not as of yet. The xbox team has not tuned the emulator enough to run it. They may add it in the future considering it's popularity, but for now your only hope of playing this game is to get an xbox original.