Make spawned turrets use projectile-appropriate SFX

Fixes #5030
Just a heads-up, bugfixes usually aren't included in the changelog.