In general, no, but generalizing can miss important local markets. I live in London and trains and busses do me fine. I honestly can't remember the last time I got into a car here; certainly years rather than months.
Big-city issues like parking and congestion charging can tip the scales quite a bit, with much better public transport than the rest of the country to compensate.
Trains also do not have to completely supplant cars to make a difference. If people take the train to work and use their cars to run errands around town it's still an improvement over driving everywhere.
Even shared bus services can made into something desirable with the right marketing and investment. The large tech companies provide luxuary coach services with WiFi to their workers and the people riding them are seemingly very happy with the services.
I mean, let's be honest here: a lot of people don't want to ride the bus because they associate it with poor people and don't want to share a vehicle with them. There's a lot of legacies of America's social problems getting tangled up with this question.
I mean even moderate-distance train rides aren't cheap. Look at the price of a single ticket from the outer zones of the commuter rail systems into the city
Big-city issues like parking and congestion charging can tip the scales quite a bit, with much better public transport than the rest of the country to compensate.