Creon is kind of caught between a rock and a hard place, as they say. On the one hand he has the rules of the gods and what they expect. And on the other side are the people of his kingdom and how they will perceive him if he shows mercy. He's damned if he does and damned if he doesn't. It is definnitely a tragic irony and makes him a tragic hero, of sorts.