Why did many people want prohibition?

Mainly because it was due to the negative aspects of alcohol consumption - fighting, addiction, lack of ambition and being irresponsible. It was also believed to be a sin and the church actually had more influence back then than it does now.