If by metanoia you mean "a change of mind," there is no virtue in that alone.
The virtue of metanoia is changing from wrong to right, from evil to good. It's not change for its own sake.
With regard to sexual morality, we already know what is right and wrong. To deviate from the Church's constant teaching here is to deviate from truth in a serious way, leading to mortal sin -- which leads to hell.