Who actually Relies on Federal Funding?

According to Business Insider,

Interestingly enough, red states, which tend to advocate for a lesser influence by the federal government, are much more dependent on the federal government than blue states. Red states combined to form an average ranking of 18.3 (with 1 being most dependent and 50 being least dependent), while blue states combined to rank 33.2 overall.​

This is particularly relevant with all of Trump's discussion of defunding "sanctuary cities and states". The backlash could be enormous, given that they take in less federal funding than they pay out to begin with. What reason would they have to continue paying federal taxes, which red states largely benefit from and they would no longer receive any of?