No, road wear is proportional to the weight on each axle to the 4th power. More axles (like this tandem-trailer truck) can distribute the weight.

Of course that means more wheels needed, so more tires and other components. Tire wear also scales with axle weight (among other factors).

Total environmental impact depends on more than just the weight. The added weight isn't good, but may be offset by the other design changes.