Uh, I seriously doubt warheads would be armed until they're fired or about to hit a target. Hence they wouldn't produce much of additional fireworks.
I accept that getting nuclear fission / fusion based warheads to explode accidentally is an extremely low probability but what about chemical and antimatter based systems. Once you loose containment on the antimatter component of a Tsunami, Cyclops or similar weapon it will explode, OK maybe not as well as designed but it will blow. Also many chemical explosives (granted not all) detonate when introduced to combinations of heat and shock so will detonate during the ship exploding.
Also what does explode in a FS era ship if not the weapons? There are several references to the reactors being fusion based which to our current understanding of fusion power the reaction will most likely collapses rather than goes out of control should the reactor become damaged. Our current understanding of fusion reactions is that the best fuel for a fusion reactor is a hydrogen isotope which in space should be fairly inert and if it comes into contact with something it could react with such as gasses from the ships life support system will burn rather than explode. the engines as I understand it are Ion derived so again the propellent will in likely hood be fairly inert or reactor exhaust.
Ok so FS with its seemingly majority nuclear based armament wont benefit overly much but there are mods which can benefit from such a system