I admire the rigor of the archaeology and physical/chemical analysis of the site, but think it’s important to note the above when evaluating the conclusions.
If this event happened, I would expect it to leave long lasting trace in oral tradition.
Tunguska was apparently visible for 500 miles (800km); for a similar event north of the Dead Sea, that would be nearly to the Euphrates valley, central Anatolia, and most of the Nile Valley.
"After eleven seasons of excavations, the site excavators [i.e., the folks affiliated with Veritas International University] independently concluded that evidence pointed to a possible cosmic impact. They contacted our outside group of experts from multiple impact-related and other disciplines to investigate potential formation mechanisms for the unusual suite of high-temperature evidence, which required explanation."
Namely, the article notes that the most probable locations for Sodoma and Jericho are two cities that show evidence for the air burst theory. Meaning story of Lot and the Fall of Jericho would have to happen on the same day, which kinda doesn't work with bible being infallible and inerrant.