Ultra Magnus is afraid of being in charge and screwing up.

He loves his duties, his city, and his planet.

In the Battle of Autobot City, he lost nearly every single Autobot that outranked him. He lost the Matrix, later, but that was a relief--except for the shame of having failed.