Device manager sees the USB interface. Disk Management does not see it, because the actual drive is toast and cannot be read.
A driver won't help. And it being the old C drive does not matter.
Unless there is some absolutely critical data on there that does not exist anywhere else....I'd just write it off as dead.