It was probably the dips in ratings that made the sci-fi channel decide to can the show.
The Ori story arc was pretty weak. And why did they have to kill off all the Asgards in the final episode? That was just cruelty! I really had a liking to those adorable little grey creatures.