Is this a 'war of the roses' thing whereas the people of Yorkshire actually object to travelling/flying from/to Lancashire? ... Where else in England do a population demand for a new airport solely because they object to travelling outside of their county?
Obviously, Church Fenton is the best located for this. Access could be created to the railway, which has regular services N towards Newcastle and to Scarborough, and S to Leeds, Sheffield, and via Selby to Hull. Only Doncaster is missing and a junction could be provided.
Furthermore its runway could be easily extended NE to a more than adequate length before reaching the east coast main line.
Is there a requirement for a new 'super airport' in the north that is likely to impact upon other airport's businesses such as EMA, LBA, MAN, HUY, DSA, MME and NCL?
Airports may be comparable to airlines whereas it seems Europe and UK are in an age of 'only the strong survive', it seems gone are the days of local airlines such as Brymon (Devon & Cornwall), Capital (Yorkshire), Air Wales (South Wales), Metropolitan (Bournemouth), Air Kilroe (Manchester), Gill Air (North East), Birmingham Executive (Birmingham), Air Chaos (Scotland) etc. etc. etc.
Likewise such commercial aerodromes as Manston, Penzance, Tresco, Plymouth, Filton, Portmouth, Ipswich, Sheffield and Hatfield have closed whilst others such as Tees-Side, Swansea, Blackpool and Coventry might be considered to be in intensive care.
MAN serves the north very well and has done so for decades past, from MAN one can fly to/from pretty much all points north, south, east and west, there is no way that any 'new kid on the block' northern airport can possibly hope to encroach on MAN's infrastructure, MAN might be considered the 'supermarket' and all the others 'corner shops'.
To upgrade Church Fenton to a 'corner shop' of any worth it is going to need so much money spending on it it would need government subsidies and/or assistance for runway extension(s), terminal building(s), rail station, main road access to name but a few and on the list of things to do I doubt that developing a regional airport that only a minority are calling for figures very highly for the government.