The difference is how long it takes for the minority of people pissed about it to dissipate and for it to become a non issue. As an example, gay marriage was passed at a state level from 2004 to 2015 and the people still butt hurt about it 7 years later are a quickly shrinking, tiny, and largely irrelevant group of orthodox religious types. Politicians who had opposing views are trying really hard to memory hole those opinions and support gay marriage for the most part. Abortion, on the other hand, has grown an increasingly organized, vocal, and politically active instead of dissipating away to a non issue we all largely agree on, which would make it an example of a tyranny of the majority issue.
The “tyranny of the majority” makes people feel smart when they say it.