Leninism has always lead to great oppression. But that doesn't mean that the people who supported it understood that. Lot of bright, well-meaning people have philosophical, political and religious beliefs that are very wrong. Also, remember, we are not just talking about Lenin's own motives and beliefs, but many if not most of the thousands of party members who supported Leninism. Most of them were sincere idealists (which is why Stalin got rid of them all in the Moscow purge trials).T
I strongly disagree that only the bourgeoisie would be opposed. Leninist revolutions take place in preindustrialized societies. That is because Lenin believed that peasants were naturally cooperative and so would eagerly adopt socialism (he got this from the Russian philosophy of narodnikism).
But that is simply mistaken. Peasants are deeply conservative and traditional, including being completely embedded in extended kinship networks, raised to value life as a farmer, and extremely religious.
Communism in a preindustrial society means tearing that whole culture completely apart, and that requires enormous state violence. Yes, a lot of them got fooled by propaganda for a while, especially before the revolution was over, but many more in Russia were never won over, and many of the ones who had supported it changed their minds once they saw it in practice.
And in fact I have read that once the Communists came to power in Russia, Lenin regularly denounced, in private, the peasants for their resistance.
So what I am saying is that leninists are generally well-meaning, intelligent people who sincerely believe it will lead to a socialist paradise, but leninism's ideas, when you try to put them in practice in a preindustrial society invariably lead to massive state violence.