A Norfolk underpass in Dereham which is notorious for flooding will not be fixed until at least 2027, a councillor has said.