Just wanted to add to this. I found this post because I was having this issue not with Metasounds, but with a regular Sound Cue. I tried setting the virtualization mode to Play when silent, but it still didn’t work. If you’ve also tried this approach and it hasn’t worked, consider trying again with a Metasound instead of a Sound Cue.
This fixed it for me. I was able to start playing the sound even if the player was out of the attenuation radius. Upon entering the attenuation radius, the sound would then become audible.