Not really. PIK is a 40 minute train ride from the centre of Glasgow; and other airports like Skavsta, Hahn and Chateauroux all provide bus service to Stockholm, Frankfurt and Paris respectively.
SNN has a miniscule catchment area in population terms - Limerick, Galway, and ... er, that's it. There's no way you could use it as a viable low cost airport for Dublin - I've made the mistake of driving between the two!
Seriously, if the government wants to do anything with the place, rather convert it into an 'open skies' superhub where long haul carriers can fly in for free and feed to shorthaul. Otherwise try and copy PIK and go the cargo route.