I wouldn't mind if the Picard series plays up the nostalgia or if it blatantly attempts to pull on the viewers' heartstrings. And I wouldn't have a problem if the show's arc is about Picard's twilight years.
But if the series overplays the Irumodic Syndrome and turns the show into Picard's death watch, then it might be too morbid and depressing to watch. I hope it doesn't go in that direction. And I don't think it would be a good way to go for the show to elicit pity for Picard because of his possible dementia and illness or whatever. Picard is a proud man that doesn't need to be turned into a frail basket case onscreen.
Also, if the show doesn't do dementia smartly (if that is what they're going to do), it could turn into a farce.
TWoK was about nostalgia, about the passage of time, and about regrets for Kirk about a family life that might have been but wasn't. The story presented those themes smartly. One of the lines from TWoK was "there are always possbilities". At the end, Kirk felt young.
Whatever the showrunners have planned for the Picard show, I hope they make it pleasant to watch.