Seems that there is no way to use the alarm on files on my hard drive, or a way to upload my files to Amazon or Apple Music.
Let me know what I am missing.
Best answer by ratty
After indexing the drive into the local library, add the file(s) to a Sonos Playlist or an Imported Playlist. This can then be selected as alarm music.