There's lovely! Good example Doc about being in the right location and travelling between centres of population where the economies of the operation makes it viable. Compare that to the OP's experience.
Indeed. I'm lucky that I live in a city with a major station, on a mainline. I can be in Leicester in just over two hours, or Winchester in 4 and a half - both comparable with driving. Both, annoyingly, require a change of trains though - ok, but a constant source of worry to me about missing connections (I'm a fretter).
As for the comparison of cost, I dunno. £66 to Winchester, £28 to Leicester, assuming I can get the cheap advance singles. Probably not so far off the cost of driving, if you factor in the running costs. But if I were to need to travel spontaneously, the cost goes up.
Of course, I don't have the choice, being car free - which I can do because I live where I live.
On the other hand, last weekend I needed to get to a village 13 miles from York, to do some work, and be there by 9am. I had to cycle, unless I wanted to get to a neighbouring village at 7.30 and walk two miles.... Not so good.