Unless that PhD is from a well respected school, and you have an impressive publishing record plus experience plus connections, you won't end up teaching at State. Maybe as an adjunct for one or two classes, but that's about it.
Academic jobs, even at no name State U's, are insanely competitive right now. The majority of PhDs will not get an academic job.
Absolutely correct, a PhD degree from state will get you an adjunct gig and maybe slightly more. But a specialized PhD for which there are no programs will yield nothing. PhD's actually end up earning less than what they would of had they left off with a MA in the social sciences.