Earlier quoted context omitted.
If the batteries catch fire the acrylic bottom will melt and automatically dump the sand onto the fire. This is a questionable setup though. You'd need massive amounts of sand dumped evenly, which requires more design and verification. Acrylic is also itself flammable. A basic water based fire suppressor would not extinguish a battery fire but it will cool it and the room, limiting spread. Let the experts design this…
Do not use water to try and put out a battery fire. It's not as bad as throwing water on burning oil, but it's not far from it.
Water can and is used to cool batteries during battery fires, and more importantly, to cool the surroundings so that the fire cannot spread to, say, neighboring banks/cells or construction materials. Modern EV fire suppression systems for parking garages use high-pressure water mists to avoid the fire spreading to neighboring vehicles for example.
The recommendation about oil and water focuses on a larger container of liquid fuel that is on fire at the surface and heated far past the boiling point of water, such that dumping a large volume of water onto it all at once causes it to immediately boil and explode, spreading large amounts of oil as a mist in the air, which both spreads the fire and causes a much more violent combustion. A water-based fire suppression system (not a guy with a bucket of water), or a firefighter with a water hose, can absolutely extinguish such a fire.
Hacking together a sand container of acrylic may well do nothing to limit the fire while simultanously giving it more fuel (acrylic) and pathways to spread to (whatever the acrylic is near).
The point is: Don't hack together a fire suppression system, leave that to an expert please.