Amazon has dramatically axed its new Stargate revival series, only six months after its announcement.