FUN at the beginning. but i guess this mod to prevent players to store large Silos and they adjust accordingly to smaller tank collections.
i wonder is there a way to minimize the cascade effect as let's say the durability of each pipe reduces the damage that it sends to the next pipe. so a smaller cascade effect. different damage value for the 3+ types of oils the thicker doesn't cascade as much where the lighter oils are more volatile and does create a longer chain reaction explosion.

to prevent players to store large Silos
yes it's a heresy

to minimize the cascade effect
looking about water turret and my broken mod "universal turret and fire departement" fix soon , maybe.
universal turret enable capsule turret and fire departement enable water capsule, can be drop by bot or by turret, but ... broken atm

water turret work fine

https://mods.factorio.com/mod/WaterTurret