I'll defend the Xindi-arc, because, all flaws side, it was a very solid, well planned, well structured arc, that had both a ticking clock AND a good mystery component that was hinted at from the very beginning and made sense in the resolution.
They also made the clever thing of adding a time-travel component to fit into canon. Sure, we know Earth won't get destroyed, as much as it wouldn't get destroyed in "Best of both worlds". But technically, it was still possible. Which makes all the difference for the stakes of a story. And we didn't know that the whole Expanse itself would have been gone by the end, but it was a natural conclusion of the arc, and not felt like a tacked on side-jump to calm down fans.
Also, it was set a 100 years before Kirk, and followed by a much bigger, much more costly war (the Romulan one), so it makes sense it wouldn't have been dropped casually into every conversation 100 years later, the same way we don't talk a lot about WWI, and focus more on WWII.
Aside from that, it had really solid character arcs planned out, for ALL major characters (except Mayweather...), and really did follow through on them and had lasting changes and consequences, that were informed by the events preceding them.
To be quite frank - I think DIS could learn a great deal from ENT season 3 and 4, as far as consistent planning, character and plot arcs and following through on themes is concerned.