Bolsheviks were great manipulators of people.They promised what people wanted to ear, something they never planned to keep, their actual goals were very different. When they solidified their power, they eliminated the other political actors who helped them. They deceived people to participate.

But you are right, in the end the opposition to Bolsheviks failed because the only serious opposition to them was tsarist who could not provide any new ideas. Bolsheviks killed (and very literally) any change of real opposition to them. When people realized the actual situation then it was already too late.