I have been using this new add-on to revert it back to Vanilla gun sounds (player-only though). It’s better than nothing.
https://www.curseforge.com/wow/addons/oldgunsounds
EDIT: I made a guide demonstrating how to get your custom sounds back with the add-on! ➴ How to Get CUSTOM Gun/Bow Sounds Back in Shadowlands