I figured out a working method if anyone comes looking at this with a similar issue.
This part of the blueprint uses the player camera’s distance from the object to lerp a volume multiplier for each of the songs.
And this randomly picks one of the songs, sets both of its files as active, delays until the end of the song, and then resets the song and sets it to inactive.
You also need to set the audio cues to “Play when Silent” and you need to turn off auto activation in the blueprint.