Why did some Northerners oppose the abolitionist movement?

They were happy to enjoy the cotton revenues earned by the slave-holding South.

Also, most Northerners simply were not Abolitionists. They were usually prepared to tolerate slavery in its traditional heartlands. But they did not approve of an extended slave-empire in the South-west because it would give the South more power in Congress.