Fixed Dune 2000 combat stats and weapon sounds

fixes #3506 and some yamls I forget during #3414.