Ran out of steam as everyone got old. That is the story of life, nothing wrong with that. Would anyone like “I Love Lucy” without Lucy?
It lost something when it went from exploration to some big bad enemy is out to get the federation storylines...Borg in STNG and Voyager, subspace aliens in Enterprise, the Dominion.
Maybe in another generation someone with some creativity will be able to revive it with some vision