Every state gets its money one way or another.
Non-tourist places get theirs by way of citizens (income or property tax)
Tourist states makes it up in sales tax (citizens and tourists), entertainment taxes, hotel taxes, etc.
Some states make up the difference by taxing a particular industry...