Syfy cancelled Stargate SG-1 because the network was pivoting to putting more effort into their other shows like Eureka which had a more general appeal. The writers snuck this cryptically meta exchange into S10E18 “Family Ties” poking at the network for how they felt the series was being mistreated.