Welcome to the forum.
Can the drive be seen in your system BIOS?
If it can with the correct ID string, then as you said the drive probably isn’t rotating.
If it can’t be seen then check the SATA power and data connectors, and also replace the SATA data connector. If it still doesn’t show in the BIOS, then it’s possibly the controller that has died.
In either case, there are many professional data recovery services available to recover the data from your drive. This has to be done in an absolutely clean environment, so don’t attempt this yourself by opening the drive.