So after confirming that neither PS5 can now even see the drive, I reformatted and installed on my PC and it works fine. So the SSD drive itself is intact. I guess the PS5 connector is different than a typical PC on the side where a screw and spacer is used. Perhaps that part was damaged and is necessary for the PS5 to recognize?
Either way, I've ordered a new M.2 SSD for the PS5 PRO to see if it can recognize a new one. If it does, then I just got an extra 2TB of SSD storage for my PC and I'll start fresh on PS5 PRO. If it doesn't, then I'll be looking to get the PRO replaced (sighs).