Sisko said that Worf would never get a command in Change of Heart because he put saving his wife over an important mission, so I think he will only be XO.
More precisely, Sisko said Worf “probably” wouldn’t get a command of his own. Sisko also admitted he would have done the same thing in Worf’s position. In the years that followed, Worf served as a Federation Ambassador and later Picard XO. I find it very plausible that with Picard (at that time, Starfleet’s most renown captain) advocating on his behalf, Starfleet would take a fresh look at the matter and reconsider.