And also good point about Roddenberry. I meant more the principle of showing a better future and how humanity overcame its problems. It made people think.
But it systematically depicts war and violence in general as not being a solution, rather a problem to be solved, a wound to be healed, an understanding to be found.
[yes, there has been few shocking exception, including Archer in Enterprise torturing an alien]
With absolutely zero respect, I think you missed the point of the episode I named, widely considered one of the best episodes ever. They literally murder someone in cold blood to start a war, to solve the problem they might not otherwise win it.
At no point did the episode show this as a good thing.
But the question isn't whether it's shown as a good thing, the bar was "Violence [is] the failure to solve a problem, never [a] true solution." Presenting the violence as necessary is still diametrically opposed to this, in some ways even more than showing violence in a positive but unnecessary light.
That's a genuinely uncommon attitude in genre fiction. Reducing it to any situation where a show posits "do the ends justify the means? perhaps!" - which is the basis of like, every piece of high-stakes TV today - does a disservice to the original critique and the TNG episodes which argue otherwise (and frankly, also to the deftness with which DS9 does usually present it).
Maybe the idea is if you set the bar high it will reduce violence and that's the best we can achieve?
I agree overall Picard was a thematic and narrative mess and Discovery needs someone who can stick the landing they're missing in the last two episodes of every season. But Roddenberry isn't god; some of his future was good in the 70s but naive or trite even by the 80s and regressive by the 90s; and some of it was never good to begin with.