Somewhat informally - when something that is mental (thoughts, emotions etc.) is disordered, that is, wrong, consistently wrong, not how it should be given the (human) nature, even after taking into account the fact that it is fallen.
There is “pathological lying” or “mythomania”, there is “kleptomania” (pathological stealing), there is “coprolalia” (pathological cursing).
So, just because there is a sin and a temptation does not mean that there can’t be an associated mental disorder as well.
I’m afraid that by the time we need a special term for condition, we are no longer dealing with temptations “normal” for fallen human nature.
Probably you mean “celibate”, not “celebrate”.
And I get an impression that you count someone as having a “mental disorder” when we get close to the point where that “someone” has to be locked into an asylum and stay there. On the other hand, I’m counting much milder forms and disorders taken under control (but not completely treated) as well.
So, let’s take a clearer example - alcoholism. It is clear that alcoholism is a mental disorder, and that it is not simply intemperance (which exists as well).
And alcoholism can be taken under control. I can easily think of an example (among people I know) where an alcoholic was able to take alcoholism under control for a long period of time, several times. Unfortunately, as “several times” hints, the disorder itself, while taken under control, is still there. And one has to be extra careful, lest it resurfaces again. For, unfortunately, it looks like we do not know how to treat most mental disorders completely.
And I do not see what is going be significantly different with celibate people suffering from self-sex attraction. The disorder is taken under control, it is not severe, but it is still there, it hasn’t been completely treated (otherwise you would call them “celibate former SSA”). They still have to be extra careful. It is still a cross.