The means of collection and treatment of it as something other than tax revenue are problematic for sure. Those should be solvable problems, though.
Your point about semi-truck damage vs lighter vehicles is exactly why I think moving in that direction is so useful. The most fair taxation would accurately take both that aspect and actual miles driven into account.