Nearly all states don't spend that tax revenue on roads. As you say, it tends to go into the general fund. I remember years ago, there was an initiative in Mass that was supposed to force the state to spend that tax money on road projects, since most of it was going into other projects.
Like P.J. O'Rouke wrote "Giving money and power to government is like giving whiskey and car keys to teenage boys."