I get the cost isn’t always worth it; the burning part is solved by putting the battery away from the home or using the proper battery chemistry; and they’re not so big.
I think it would be best to have a local community battery that covers a neighborhood’s needs rather than huge ones for a region or single home batteries.