There are calls for an investigation after Wirral's £20m sea wall failed to stop homes and businesses being flooded.