Apple - Does the “Put hard disks to sleep when possible.” option in macOS have any affect on SSD drives?
According to Apple:
Put hard disks to sleep when possible
This setting powers down the hard drive motor when you aren't reading or writing files from the drive. Solid-state drives (SSDs) don’t have moving parts, so this setting doesn’t affect Mac computers that use only SSDs to store data.
Consider deselecting this option if you have an internal or external non-SSD drive and you use apps—for example, pro audio or video editing software—that work better with continued read and write access to the hard disk.
Source: Apple: Use the Energy Saver settings on your Mac [Bold emphasis mine]