Yes, the hard drive platter spins constantly.
However, the typical MTBF for modern hard drives is years. So, your drive is apt to be replaced for reasons other than being worn out first.
Keep in mind, that the most wear and tear occurs during the startup and read/write phases, not the idle run time.
Anyhow, most motherboards have in the power management section of BIOS settings the option to turn-off the hard drives after they have been idle for a set period of time.
You can also set up rules in Windows power management setings to shut down the drives after a set period of inactivity.
If you really want the extra drives to be off, Trios makes a hard drive selector switch.
The switch is designed to make it easy to switch between different operating systems on a single computer. But I see no reason why it could not be used to disable extra hard drives.
Keep in mind, that your motherboard and operating system will only recognize drives that are present when you boot the system.
Chas