The Clock app on iPhone does play songs, but in order to do that, it needs to be downloaded on your iPhone. That's why, whether you're using Apple music or simply using MP3 to transfer through iTunes, make sure the file you wish to use as your Alarm is in your iPhone's storage—not the cloud.