I, personally, thought this episode was pretty good. I understand a lot of people think it has nothing to do with the crisis with the Ori and they'll never solve their problem with episodes like this, but that doesn't make the episode any less good.
Personally, I get tired of hearing about the same bad guys week after week. Sure, I want to know what happens with the Ori and how they're going to defeat them, but I like to see a little variety in the story line. It gets a little monotonous after awhile.
This is the shows tenth season and I don't think episodes like this one will get it canceled. 10 seasons for any show is a long long time, I hope the show continues, but only time will tell! It's amazing what SG-1 can accomplish in one episode. Who knows, maybe they'll solve their Ori problem in the Season Finale.
I thought this episode showed more of Vala and who she was as Katesh. I hope to hear more about Vala's past in the future.