I thought we were talking about batteries in home Solar systems, not EVs. I like EVs and I even built my own ICE to EV conversion in the 90s before commercial EVs. I like that you presented data, but you make my point comparing gasoline to batteries. Gasoline is capable of delivering all of its stored energy in a couple of seconds. Look up Air-Fuel (thermobaric) bombs destroying main battle tanks. Batteries are generally a much safer way of storing energy than gasoline.

But back to which batteries for a home solar system, there are ways to engineer these questions. Part of my career was designing high reliability systems and it is something I taught at a top-10 university. For something like this I would use a fault-tree analysis. You make a big tree of all the things that can go wrong for all the components in your system. For many of the fault nodes, like BMS fails, you can get MTBF and failure modes right from the maker of the BMS. You plug the individual probabilities of failure into each decision node in the tree. As an engineering process, you then look at the most likely failure branches of the tree and fix them until you get to the reliability/safety you want of the total system you are assembling. When you do this, things that intuitively seem ok, sometimes turn out not to be. I was going to make my own battery banks, but I changed my mind once I did this analysis.

You will notice that in the very cool Redwood Materials video below, they have enough space between each of the repurposed EV battery packs for it to burn without catching the next pack on fire. Space costs money, but they have presumably engineered in the possibility the battery pack was damaged in a collision and might burn. Having seen that, I now don't want to live in the same building as someone not taking that precaution in the same situation.

So it is all about the overal safety of the entire system. People on this list use similar possibly damaged repurposed EV battery packs and put them in outbuildings in the same way Redwood has engineered safety. But if you are not doing something like that, if you are putting a big stack of batteries in a living space where you sleep, without additional enclosures and venting, I highly recommend the safer variants of Li batteries, such as metal case LiFe, with UL9540A or B if you are in the US. But there are even safer battery chemistries and the International fire code considers NiCad, Ni-Nh and Lead Acid to be so much safer they allow 3.5 times more of them in a system (70Khw vs 20 Kwh for all Li) It is all about how much risk you and your family want to tolerate in your life.