The reason that the Missouri Compromise did not have lasting effects is:
It only applied to the lands of the Louisiana Purchase.
This limitation meant that as new territories were acquired or settled beyond the Louisiana Purchase, the compromises established by the Missouri Compromise became less relevant, leading to new conflicts over the issue of slavery.