Without knowing their reasons, it isn't possible to judge.
My parents would do it for me...
Except currently Dm isn't driving at night until she's had her cateracts done and df can't drive after he's taken his medication.
My and dh have both done emergency runs during the night for people, including a stranger who knocked on the door at 2am...
But there was one time I was asked and I said no, because dh was away and it would have meant taking 3dc under 8yo with me, including one who was vomiting regularly.
I think another question is was is stormy round you? If your area was flooded and trees down then that makes a difference too.
Also it may be a 40 minute journey for you, but how far for them? Don't forget they would have to get home again afterwards. If they live 20 minutes the other side of the station it may only take 40 minutes for you, but double that for them.
And what were your plans for getting home anyway?
If the train company stopped at not your terminus station then they're obliged to get you to your station. So what were you expecting to do before?
Presuming you don't drive, be honest, how often are they called on for a lift. I bet it's more than you think. If they're asked "just a lift to the supermarket" (and wait around for a lift back) and "can't you just drop me at work on your way" (15 minutes out of their way) then they may have had enough.