“Has problems” is an interesting way to gloss over we’ve got an administration that has openly declared war on any state he didn’t win and will no doubt withhold funds from the states he doesn't like, the same ones that will be providing the vast majority of the revenue in question.
I literally cannot think of a worse way to enforce this than letting the federal government collect the tax and then distribute it to the states as they see fit.