Sydney Sweeney only took the role in Madame Web to strengthen her working relationship with Sony