I think you might have a wrong impression of the tube. I use it quite often but cannot remember when I last saw vomit on a train. If at all rather on the platform as many people try to get off if they feel very sick but don't make it to the exit of the station. There are certainly many drunk people but also a fair share of people going from/to work late at night.