When does the emotional pain go away?

It doesn't disappear as such.
It becomes a part of your past as it should be. You just stop living in your past.
When you accept it, take accountability for it, heal it.

It eventually wanes and you accept it

When the bottle of tequila is empty.