NVMe drive vanished from Windows and BIOS after data on it was corrupted

So I just bought a used PC and it had two SSD on it, one of them was a 1TB NVMe I used as a second drive for my Downloads, Apps etc.. (the other drive was dedicated boot drive). I configured my Downloads folder to be on D:\\ (the drive in question) so windows downloads everything directly there and it all worked fine until -

Today suddenly when trying to access 'Downloads' it gave me an error stating: "A Device Which Does Not Exist Was Stated". After some attempts to change the 'Downloads' folder location back to C:\\, I realized Apps that are installed on that drive aren't showing up on the task bar either, and realized they too are locked in a mostly inaccessible drive. I eventually succeeded in changing the 'downloads' folder back to default, then back to the D drive location, but by then many other things on the drive were inaccessible too so I ran Chkdsk /r on that drive hoping it will straighten things out.

The disk check ran for quite a while. When I revisited my PC 30-40 minutes later windows was up and running but my drive still wasn't working, and now completely inaccessible but still showing up on file explorer. I restarted again and weird noises started at boot - hard disk sounds I didn't know SSD's made (I thought they had no moving parts). It took a long time and it wasn't booting so I hard restarted by pressing the button and turned it back on and then the noises just kept going and no boot screen or anything. I restarted and went into bios and only when I exited it without saving the computer booted but now the drive was completely gone. It doesn't even show up on BIOS.

Can it be that data corruption is making it invisible to the BIOS even? Is that possible?

Is it a sign the disk was failing anyway or did what I do fry it?

And is there any way to format it or reset it or is it toast?

Thank you for reading and possibly helping out 🙏