Sky will no longer have exclusive rights to hit US TV shows such as Succession and House of the Dragon after a legal row with Warner Bros Discovery (WBD) over Harry Potter.