This assertion isn't true. Federal policies already heavily favor funding Red, rural states over more urban states. It "sounds" true when you think about a person/household but when you factor in the other state services being funded (i.e. roads) it falls apart.
https://taxfoundation.org/federal-taxes-paid-vs-federal-spen...
5 of 24 years (1981-2005) CA has received less. And if you look up the scattering (but less concentrated) stats from 2005-2017, CA has been getting less than 80% of its money back from the Federal government. So its really 31 of the past 36 years that CA has been drained to help red states.
https://taxfoundation.org/states-rely-most-federal-aid/
> If you're a progressive this should make even less sense: rich states are currently keeping additional funds for themselves local, in their rich states, via high taxes, that are then shielded from the federal government via deductions.
That is a strawman.
Progressive taxation has nothing to do with aggregate wealth and everything to do with individual wealth.