It doesn't take a college degree to be a pilot car driver, but it does take a certification process that goes over the history of the job and what will be required of you to do the job safely. Since there's no federal certification, each state operated in will require its own courses for the company though there aren't many places to receive proper training.
The training will teach you proper sizes when dealing with oversize loads. The maximum a vehicle can carry is 80,000 pounds gross, 20,000 pounds for a single axle, and 34,000 pounds for a tandem axle per load. Weight limits are important, especially when traveling over bridges that don't allow trailers that are too heavy to cross. These courses will teach you how to get information on the roads itself, like how high overpasses are and whether the cargo will fit under or how wide the roads you will travel are. Through certification you will learn about tow trucks, understanding how long and wide the pole a haul carrying is, and how to talk to dispatch.
To get started, your vehicle will need to be insured for business use as a pilot car. You will also need to purchase a business liability policy in addition to auto insurance, as a precautionary safety. Vehicle insurance does not cover truck accidents, even if you are in the clear.
In order to escort trucks and motorcades properly, your mode of transportation needs to be in good shape. You will need to outfit your car with a good CB radio and antenna, an oversize load sign to the roof of your car. You will also need two flashing amber lights, one revolving amber light, two red flags, extra flags in case those fail, and several other pieces of safety equipment.