Enterprise not being a good series is your opinion I would say. I don't think DS9 was a good series, and people love it. Enterprise died because it was on UPN. It did have low ratings for ST but it was still their number 1 drama. UPN wanted to have a new image and new audience and Enterprise didn't fit. So they stopped promoting it and changed the times around (like FOX did with Arrested Development, which was also a good show undeserving of an early cancellation).
True. Plus UPN didn't have much market coverage in the first place. The moving timeslot, the many preemptions for sports coverage...many people who might have watched simply couldn't find the show. A niche show (which sci-fi is) needs nurturing, but UPN didn't seem to have a clue how to do it. And yeah, wrong demographic. Plus the explosion of channels, more competition, changing of the guard at Paramount...ENT was a victim of changing times.
I have a hard time believing that the set is nowhere to be found, I mean wasn't that the original set in in a mirror darkly?
The TOS sets for IaMD were painstakingly recreated by the art department, from scratch. That's one reason those episodes cost so much.
As for the ENT standing sets, they (and just about everything else Trek-related on the Paramount lot) were trashed, literally bulldozed out of existence. The prevailing thought at the time (I believe Doug Drexler talked about this on
his site, he was a witness) was that someone in charge had a thing against Trek and wanted to make a statement. Petty.
Plus, really atypical. When studio sets are no longer needed, they are usually put in storage so this or that wall or part can be refurbished and re-used on another show. That's why we saw so many reworked set pieces and decor from one Trek show to the next. Destroying all those sets and costumes (except for the stuff they auctioned off for $$$ ) was wasteful. They could have held an "estate auction" of Trek sets and props and Trek fans would have paid a mint for it all. DUMB.
So if ENT came back (ah, we can all dream), everything would need to be rebuilt, which only a major studio would be able to afford, and Paramount is putting its money into Abrams Trek.
I like Abrams Trek just fine, but, well, I miss Enterprise. I thought there was great potential for another three seasons.