Filmed during a flash flood, the footage shows a rider completely helpless as the volume of water drags him and his bike down the road