This whole time I've been confused how investing more money in roads is compatible with our climate goals.

It is compatible with our goal of getting from point A to point B safely. Climate goals are not the only goals, and if you look at this bill carefully, you'll see that they are quite secondary to other goals, which reflects the underlying political reality.