A good example is ST3 in the Seattle area. Seattleites and their neighbors overwhelmingly supported the expensive and radical expansion of the rapid transit system in the area and were more then willing to pay the increased taxes for it... Opposition came mostly from the eastern parts of the state even though the taxes are only to be collected in the proximate areas to the expansion.
In fact I can’t recall any examples of people calling for the cancellation of existing public transit. The backlash is usually against planed expansions from distant areas.
I’ve seen a few places on the East coast where voters resonate with political candidates that decry the subsidies to public transit, and call for increases in fares or decrease in frequency of bus/train service.