What the seller's answer is worth
It is worth having and it is narrow. “No flooding during our ownership” covers however long they have been there and whatever they remember, and says nothing about the decade before that or the decade ahead.
The Lexsure wording below is candid about the other half of it: the conveyancer has carried out no independent or formal investigation into the risk of flooding. That is the normal position. Investigating flood risk is not part of a standard conveyance, and the gap is yours to fill or to accept knowingly.