it doesn’t show up in file explorer, disk mgt., device mgt., bios
I’m sorry to say this, but the fact that it doesn’t appear in BIOS/UEFI is a very bad sign.
Have you already checked this in multiple different SATA ports? It’s the most important part. If the drive doesn’t identify itself to the motherboard you won’t be able to do anything to it with software.
Do you have an external enclosure/SATA adapter for USB? The next thing I would check is to connect it that way after the computer has fully booted and see if it shows up at all. Also try plugging it into a different computer if possible.
I also want to recommend smartmontools for monitoring your drive health going forward. This allows you to interact with the SMART functionality built into the drive.
Pain is a great teacher.
If you had the hardware to build a robot that could “feel” the world around it, and you wanted it to self-teach how to move around on its own (so that you don’t have to pre-define movement paths), you would probably program in a system that could interpret potentially damaging sensations as danger/bad and avoid them automatically (too hot/too cold/too sharp/too hard/etc). That system would essentially be a pain response.