Despite the good premises, evidently, the series has failed to achieve the goals set by Netflix which is preferring to invest in something else in a rather complicated moment of its long activity. The last quarter was marked by a historic drop in subscribers, employee morale is not skyrocketing and there have been some staff cuts. Never as in this phase has the giant led by Reed Hastings have to carefully weigh investments to return to growth at the desired pace.
As for Space Force, De gustobus: It may not have been a memorable series, but there is also (much) worse in the vast Netflix catalog. Season 1 and 2 continue to be available to anyone who wants to get an idea.