This is how a lot of parliamentary democracies work. The president has very little powers and even the ones they do have are mostly ceremonial that can be overridden by the actual government.

Though nothing is stopping the cult of personality from forming around the leader of the government (prime minister).