Is there some well established way to make some very visible but not structural part of a bridge to collapse after an overload, to scare people and make them report the problem?
A really simple catch all, that isn't quite accurate for all cases would be to put a sign over the top of such a bridge,that limits the height of vehicles crossing, excluding trucks with the tall trailers. Would not work for loads that aren't tall though.
Often these "car only" country bridges are just some large wooden beams over a creek; even a simple concrete culvert replacement would be truck-proof.
Some of them do things like this: https://www.alamy.com/stock-photo-small-car-suv-crossing-the...