Star Trek was very good at being made cheaply. That’s originally why they had transporters. You don’t need to film how they get from one location to another. And they did things like Shuttlepod One in Enterprise, where the entire episode literally takes place in one room.

Both TOS and TNG did both come very close to total cancellation though. I believe it was Lucille Ball that saved TOS