Much of that funding goes to subsidies (farming, energy, etc) for which the whole country enjoys the benefits, if not proportionally. A state like SC that has a disproportionate amount of military bases is going to receive far more per capita government funds, though the local SC taxpayers only get marginally more benefit than the rest of the country.
That's not to say you are wrong that rural states get better de facto tax treatment than urban-focused states but it's a bit more intertwined than it sounds.