But it isn't just Resolutions.
Its every man in every episode in every series.
(Except Kirk. But that explains much.)
doesn't preclude J/C.
In some ways it helps.
Remember There's Something about Mary?
"You don't walk about with a fully loaded weapon".
Chakotay would be less of an idiot dog, and more likely to seem like an eligible mate if his penis doesn't have the strength to take command and throw him at every piece of presented tail.
Considering the XO's continual perpetual state of serenity it's likely that his lizard is almost always drained.