So compare it mile for mile with other forms of transport.
Euston-Manchester Piccadilly by road = 199 miles according to AA Route Planner.
It'll take you (according to them) 3hr 53 mins. In any decent diesel engined car you'll do it in 3hrs and it'll cost you around £27 in fuel. Add another tenner in running costs and you're looking at £40 tops.
So train vs car = car wins by £108.
If the Government really wanted us out of our cars they'd have offered a genuine alternative.
As it is, the rail network is used only by those who don't have a choice.
Exploitation of the masses, if you please.
Anytime fares as you rightly say are almost non-starters except for emergency requirements.
However compare them with Advance fares.
For next Friday for example ,you can get an advance single EUS-MAN for £32.50 on any of the early trains compared with the £148 walk up.
As I say , Anytimeis not an option except in desparate circumstances.
People doing this journey regularly will be almost certainly buying advance which beat car costs.
A couple of points on the car costs.
It will take 4 hours on most weekdays because of sheer volume of traffic at peak times.
Also you can add at least another Tenner for parking costs.