Wired up the Red Alert special infantry death sounds

@reaperrr already wrote the trait in #5236. While writing the changelog and searching the bug tracker I noticed that this fixes many other issues already posted. This now does the YAML changes proposed in #4210 to finish it up.