No they are not all for the airport.
They form the South Yorkshire Transport plan.
The airport link road is for the airport. The supertram link is from Sheffield to Rotherham, and the Barnsley link road is from Barnsley to the M1!
They are up against each other for the money on offer.