It really is an absurd concept.
Was there a really big flooding incident in early civilization? Probably. The ancients passed it down in oral legend. Was it local? Undoubtedly. Did it almost become allegorical after generations of telling? Almost certainly.
Noah's Flood makes no sense given what we know about science today. It's a good checkpoint to see who bases reality on some fundamental faith and who uses the brain God gave them.
Actually I see science moving back towards scripture every year.
There is greater recognition of the role of Catastrophism in the formation of the fossil record than there has ever been.
Also, there is greater recognition that there are problems with individual dating methods. Science is far from giving up the house of cards they've built, but there are individual admissions that certain technigues have problems.