That's a very good way of putting it. They had the opportunity to go for a more typical Star Trek uplift, with some franchise-friendly "and their general, non-specific adventures continued…" but steered hard into "Pyrrhic Victories taste awful," and leaving the cast in need of doing a lot of work.