[ImperialCrown]

Welcome to Allpar. Auto parts stores can't diagnose and it is wrong for them to sell you electrical parts that can't be returned because it 'might' be this or that. Coil packs are generally reliable. You need to figure out what the vehicle needs and replace that.
Do you have 12 volts in at the center of the 3 wires at the coil pack? Do you have fuel pressure?
Do you have access to a good scan tool that can watch the crank sensor signal while the engine is cranking? Any history on the vehicle?

 

[kjneild]

Plan on renting a scanner tomorrow or the next day. I have owned this vehicle since 2006, no major problems until now. There are some wire harness issues but only affects the ABS. The check engine light has been on for awhile, code was for something like gas cap issue. Never figured it out because it never ran bad. Lots of electrical weird issues like dash lights flashing, headlights going out, brake light out, but never had engine issues.

 

[ImperialCrown]

The electrical issues could now be affecting the ignition system?
Could the dash light flicker be broken solder joints on the cluster circuit board?
Does a dash top fist 'thump' bring them back?
Have you ever seen the PRND3L all in boxes at the same time?

 

[kjneild]

Pulled two codes, P0352 & P1193.
Yes, I have seen the PRND3L all in boxes at the same time.

 

[ImperialCrown]

If you still have the tool, write down the freeze frame or snapshot information where everything was engine-running-wise at the moment of the fault code happening. If it gives 'starts since set' that will help determine a time-line. The 2 codes probably aren't related and the P0352 is just 2 cylinders of the coil primary failed. It would still fire on 4 of the 6 cylinders. It might also have been set at a moment of stall when the PCM was looking for the coil to switch coil #2 but somehow it didn't. There are 3 separate coils inside, firing 2 cylinders each.
The air temp (ambient) sensor is mounted under the front bumper and made of plastic and easily broken. It can get bumped. This may be the fault code P1193.
Neither one would keep a vehicle from starting and running, albeit misfiring badly if P0352 was active..
The boxed PRND3L is usually an indication of lost communication with the cluster. This can prevent starting. Sometimes it is intermittent and a fist-thump can 'reconnect' a broken solder joint momentarily. The cluster board can be removed and the affected joints reflowed.