A video has shown how floodwater has swamped a pitch at a popular football club - and locals are astounded at the scale of the flooding