Won’t do much good unless you prohibit the states from raising their income taxes to capture what the feds stop collecting. Th interplay of state and fed is a long-term waltz designed to keep governments from collecting as much income from the citizens as the citizens will tolerate.
Also, we sometimes forget that much of the power of the federal government has been accretions from the cowardly state governments who want monies but don’t want the citizens blaming them for high taxes. So, in return for being the taxing “bad guy”, the fed gets to flex more and more power against both the states and the individuals. While changing the source of federal funds would work somewhat, you have to rein in the states before the citizens would see the real benefits.
Ah, the beauty of living in Florida. Sunshine and no state income tax.