Looks like HomePod has its own alarm sound that is currently not customizable. Would be nice if you could set the alarm to be any song from the Apple Music library like iPhone. My Echo can do that with Spotify via voice command, though I find it to be sometimes inconsistent.