Well, now that I know that one of my spark plug wires are pierced and that it's shooting sparks, I need to know what problems can come out of this.

Right now my car barely even idling, and even that is extremely rough, most of the time just dying on me about ten seconds after I start it up, it died on me four different times trying to get it out of Autozone's parking lot. The oil pressure is always hovering between 30 and 0, when I stop and idle, it will die.

I need to know any and all problems a sparking plug wire can cause.

I have an MSD ignition, MSD Blaster Coil, and MSD Plug Wires.

 

Dude just replace the plug wire and see what gets fixed. If there is still a problem then it will be much easier to diagnose when that is out of the way.