Just 51% of the local road network in England and Wales is reported to be in good condition, research suggests.