Is there another term for someone who cannot handle consuming large amounts of alcohol besides the term 'lightweight'?
"Can't hold their liquor" or "Can't handle their ale" are in common use in the UK.
Can't hold their drink/liquor
if someone can't hold their drink, they get drunk after drinking very little alcohol
cheap drunk (from Urban Dictionary):
Someone who easily gets drunk. They could have 3 shots of a 40% strength alcohol and they're gone. The person is cheap because they don't have to spend as much money on alcohol to get drunk.
two pot screamer (plural two pot screamers):
- (Australia, colloquial) One who becomes talkative or rowdy after consuming a relatively small amount of alcohol; one who quickly becomes intoxicated. (Wiktionary)