Welcome to the TH community and Happy New Year, JT-Jarod!
I'd advise you to try plugging your WD Red drive with a different SATA cable and also swap the SATA port itself. It's possible that either one could be faulty and not supplying the HDD with enough power for Disk Management to recognize it. Another thing you could try is the 'Rescan Disks' command in Disk Management as well, hopefully, the hard drive will pop up afterwards.
If you have access to another computer, I'd also try connecting the WD Red there and see if it will get properly detected there.
Keep me posted with the troubleshooting. Hope this helps you.
SuperSoph_WD