I’m not that surprised. The show’s very nature gives it a limited shelf life. Part of the fun of Trek is watching the characters develop and advance in their careers. Eventually they’re gonna get promoted past what can be called lower decks.
I’m a bit pissed off that they’re canceling this and going ahead with the section 31 project, but I find section 31 to be tedious at best, and that it undermines Star Trek’s message at worst. “Your utopian post-scarcity society that celebrates diversity can only exist because of these unaccountable fascists slinking about behind the scenes.”