I found the weapon sound effects and it looks like its not possible to add new sounds; I also found the Sound ID does not refer to the Sndlist.lst file but to the third letter on the acm file name which is the ID (Example: Minigun Sound ID: 76=4Ch (4Ch ASCII character = L) so the fire SFX for minigun would be WaL1xxxx1.acm (the second letter on the name is the id for the action ( a=fire, r=reload, etc)). If you look at the mapper you notice the Sound ID box lists ids 0-9 then A-Z and finally some symbols (!, @, #, $, _) so it looks like you can only replace existing sound effects and not add new ones.
Maybe there is a way to work around this and add new sounds, if these sound ids are not defined in any internal list just try naming the new files following the same pattern (if last sfx uses the id _ (5Fh) then use next characters in the ascii table: `, a, b, c, (60h, 61h, 62h) so the new file would be called Wa`1xxxx1.acm, Waa1xxxx1.acm and so on) This would mean you could not use the official mapper to edit the Sound ID on the prototype but you would have to do it with a hex editor.
I haven't tried this but it might be worth to give it a go so if any of you guys know any other way to add new weapon SFX, I would like to hear it.