I was going through the workshop and I found this mod Arsenal Extension - Hydra Torpedoes

I liked the idea of adding multiple warheads a M.I.T.T. if you will: Multiple Independently Target-able Torpedoes( instead of MIRV). However, I wanted this to feel balanced and also try to tickle all the right boxes for stress/reward. Here's kind of what I'm thinking, if I can get it working....

Each torpedo will break up into a number of new torpedoes with lower yields. I'm thinking about 1/3 but maybe that's still too much? or not enough?

Common:0-2
Uncommon:0-3
Rare:0-4
Exceptional:0-5
Exotic:0-6
Legendary:1-6

The 0 representing a "misfire" as it were. To prevent this from feeling like an overpowered MUST have. My thinking is that this misfire might be the difference between your last torpedo saving your life from the squad that just jumped in and it being a dud, so you need to rely on your dog-fighting or running. It also should feel rewarding to find/use better torpedoes as they have more warheads and the legendary ones never fail. That would be my hope anyways.

Again this is based on the assumption I can figure out how to make it work.

Thoughts?