Good news. The Megabus drop off location in Charlotte (at the Charlotte Transit Center) is also the very same location for the Sprinter bus that goes to the airport. You just have to connect up the schedules. Fare is $2.00. Link for the Sprinter:
Sprinter