Tarkin was many things, but a dumbass was not one of them. Over-ambitious, definitely. Arrogant, sure.

I guess you could make the argument that he was dumb because he thought the station would force the galaxy to submit instead of fight back harder.