I definitely see Worf progressing to the rank of Captain in-universe but he will always only be a supporting character IMHO.
Have to agree.
Worf, as a character, has had his time. There have been loads of episodes on him, his honour, his family, his Starfleet-Klingon conflict, and so forth. Plus him putting the good of the one ahead of the many all but ended his career.