I don’t think Tarkin has to be a Sith - more that he’s a smart cookie and knows how the politics work. He knows that if he could find some way to take down Vader, it would make him look more powerful/valuable in Palpatine’s eyes.