Second, the size of the vehicle is important. Larger vehicles like trucks get these poor bridges lifespan shortened drastically. Trucks and busses could be rerouted on safe bridges and so on.
I generally am not afraid of bridges because they have convinced me that they're safe but if a bridge were to collapse under me and I'd make it out alive I'd probably have a bridge phobia.
So you could start with the lowest hanging fruit, the bridges that are in such bad condition that people post pictures of them on Twitter.
The problem Pittsburgh encounters is even demolition costs money. Can't squeeze blood from a stone.
Of course, this bridge only carried about 10 cars a day, mostly as a novelty, prior to closing. It's an entirely different animal to close a bridge in a major city.
Minneapolis/St. Paul managed to adapt when the busiest bridge in the state collapsed.
Make some free. Let the communities who need them pay for them.