I agree that our public transport is lacking in certain areas.
A quick search seems to suggest that there is a Megabus that leaves at 22.30 via Newcastle and scotch corner and arrives at Wakefield/Wooley edge at 03.30.
Maybe a little forward planning would help to check before travelling if there was any onward travel after his flight.