I imagine Tarkin doesn't care one way or the other. Anything to advance his own aspirations to power is all he cares about. Interestingly, Motti is arrogant enough to insult Vader's belief in the Force. Makes me wonder if Motti doesn't know of the Emperor's dark abilities. If he knew, he'd definitely be less insulting.