I am no expert, but those state road funding figures are highly misleading.

It ignores all direct federal subsidies on roads.

It ignores the original moonshot-scale creation of the interstate highway system, which was obviously not based on user fees.

It ignores related health costs caused by dirty air.

It ignores the intangible but very high cost of turning cities into noisy, unpleasant, and dangerous places built for cars instead of humans.

It ignores the less tangible subsidies involving things like military to keep oil flowing.

It ignores current and especially future costs due to a rapidly changing climate.

...and probably many other things.