Yes.
Does the state tax go away or what?
Not unless the state ends it. The federal government cannot repeal taxes that the states enact.
Hotels/Motels already charge something like 14-18% tax.