When in the Mission Editor, you can make multiple units and list them as playable, thereby enabling you to continue with that unit after your current one dies. However, when you die, that light sad music seems to appear and the gun sounds no longer work. I have tried this both as OPFOR and BLUEFOR with no change.
To sum up, once you die and select another unit, you can no longer hear any weapon being fired.