In my view the question about archaeological evidence of “a major local Mesopotamian flood” should be placed in a broader context.
We could ask:
Is there massive archeological evidence of Jesus Christ’s Resurrection?
Or is there such evidence of a historical Moses, Exodus of Israelites, and crossing of the Red Sea?
In my view the answer is NO to either of these two questions:
Regarding Jesus Christ’s Resurrection:
We believe in it on the basis of the testimony of many persons (Apostles, Maria Magdalena, disciples etc.), who reported to have seen Him resurrected, and whose accounts are trustworthy from the perspective of Salvation.
Nonetheless, one cannot yet definitely exclude that the Turin Shroud provides evidence for the Resurrection, and the search for biologic evidences on this twill linen cloth with more sophisticated methods is still going on (see for instance here).
Regarding Moses, Exodus, and the crossing of the Red Sea:
We believe in a historical Moses and the wonders God worked out through him on the basis of the authority of Jesus Christ, the Son of God, who in different occasions referred to Moses and his wonders as narrated in the Old Testament. In particular, Moses’ authority is confirmed by Jesus in the episode of the Transfiguration upon the mountain.
For the time being it seems safe to claim that “no archaeological evidence has been found that confirms the crossing of the Red Sea ever took place.” However the debate on archaeological evidence for and against the historicity of Israel’s Exodus from Egypt is far from being closed (see for instance here).
Regarding Noah’s Flood:
As for Moses, we have to believe what we are taught by Jesus Christ and Peter’s Letters about Noah and the Flood. In postings in the thread “My theory about the Flood” I have argued that this teaching supports the following conclusions:
-
Noah is a historical figure and the Flood a historical event.
-
Nothing speaks against interpreting the Flood as local from today’s geographic perspective.
-
From the perspective of Salvation one has to accept that, excepted Noah and his family, all humans endowed with free will and capable of sinning living at that time perished in the catastrophe. This may have been a population of hundreds of thousands concentrated in a rather little area.
Nonetheless, to date there are no compelling reasons to pin a connection between any of the archeologically evidenced floods - at Ur, Kish, or Shuruppak - with neither the Flood of Mesopotamian literature nor Noah’s Flood. The reported archaeological data look somewhat paradoxical and raise questions: It is for instance unexplained how a massive Flood at Ur could have happened without letting any trace 11.81 miles away, in Eridu (see map). So probably we have to await renewed excavation and better scientific techniques to decide the question of whether the region around the first Sumerian cities was the scenario of Noah’s Flood.
In summary, interventions of God in human history (like the Resurrection, the crossing of the Red sea, Noah’s Flood and other similar ones) are unique events we believe on the basis of trustworthy testimonies (Revelation) and that could have happened without leaving “massive archaeological evidence”. Nonetheless the effort to find such evidence cannot be disqualified as nonsense.