Hello,
I’ve found away to implement in Niagara using the (experimental) “Component” renderer and putting a FModAudioCpt.
It works more or less (Not working in preview but working in play mode).
Issue is I need to put the particle lifetime to EXACTLY the event length, otherwise the sound in the event loops. This is really annoying, and I can’t find why.
If you can try my system and investigate why sound loops, you would be my hero 
Best;
Mathieu