I never really thought about the fact that Tarkin knows who Darth Vader actually is and he probably knows that the entire galaxy is run by a Sith Lord.
In the Tarkin book, he has his suspicions about Vader but doesn’t have confirmation.
Apparently in the new canon, very few people know the Emperor is a force user. If he is forced to use his powers- there are no witnesses or survivors.