>Beyond preventing the distribution of pirated games, why do console manufacturers put so much effort into preventing unvetted code from running on their hardware?

It is to prevent piracy. If you could run any code on a retail console then all you need is to get an image of a game, stripped of authenticity checks ("cracked"). This is how piracy on PC and other open platforms works.