'Game of Thrones' spinoff starring Naomi Watts was axed after $30 million spent on pilot On Demand News