No - as a society we cannot say that its a “vast net” positive. The externalities that harm the commons are not accounted for.

We (or lobbyists) resist having carbon costs included in the prices we pay at the pump.

Edit: More transportation is good; I am not throwing the baby out with the bathwater, just that our accounting for costs makes things look better than they are.