In my opinion, a character with no viable avenue of development, it's better to give them a meaningful death than a meaningless life.
In a story I wrote a couple decades ago (the last half of which is now lost with the site it was on), I had a difficult love triangle: the female protagonist chose one guy over another, but the other was a genuinely good person whom I liked. Since I had not created a suitable alternative love interest for him, and didn't want him just hovering there through the years, pining for the girl he had lost... I killed him off. His death was a final, shattering message about the horrors of war. Instead of a life that was counterproductive to the narrative, he had a productive death.
Given that Harry and Chakotay had very limited value to the overarching Voyager narrative, giving either one a heroic and emotionally gut-wrenching death might have been a good thing.
Depends on your perspective. I consider the whole "holograms are sentient" idea to be questionable at best anyway. But TNG walked with it (Moriarty), DS9 jogged (Vic), and VOY ran full tilt, far and fast.
It only works if we actually see them reunited at the end.
I shipped those two ever since "Resolutions". Kind of like I shipped Caspian/Susan after seeing "Prince Caspian". Still do, in both cases.
Tim Russ ended that early on. He told the showrunners "I don’t cheat on my wife, and neither does Tuvok."
He was. He was the only VOY character who got a satisfying ending within the series. At least three other VOY characters never got one at all, 23 years after the series ended.