This is a pun on 'drain' which in this context means the plumber was deprived of strength or vitality, butit's also used because drains are a channel or pipe carrying off surplus liquid, especially rainwater or liquid waste, which is what plumbers specalize in 
The plumber had to quit his job because it was too much of a drain .