Leadership shake-up comes weeks after Skydance's takeover of Warner Bros Discovery, with both executives set to return to filmmaking