Mass transit makes a lot of sense. It can even be profitable when you have a lot of people going in the same direction at the same time. But whenever you're on a really empty bus or train - someone else is footing the bill for your very expensive ride home.
And you can have trains that come much less often (like, say, once an hour) to collect the stragglers. Less wagons in the trains.
Hello, Tokyo has no trains from 1-5AM. So you can simply plan around it (either going home before 1 or knowing you'll be out til 5).
There are deliveries to be made, buses to ride (even with a good train infrastructure), people who can't take public transport, etc
It's simply naive to think otherwise
[1] http://www.uspirg.org/sites/pirg/files/reports/Who%20Pays%20...
A few extra late-night runs don't particularly move the budget. It's a bit like manufacturing - once you've designed your product and set up the production line, doing a run of 4000 items isn't much different to doing a run of 5000 items.
You guys are framing this debate as if going out and getting drunk in a bar is a necessity for life, it isn't.