Traffic was backed up for hours after the tractor-trailer lost its load, damaging a pilot vehicle behind it