This is a more informal/dialect-driven/less correct (opinions will vary on which it is) way of saying
James Hetfield looks pretty torn up in those pics.
Looking torn up is another way of saying that something looks run-down, worn, or broken-down.
A rather literal example:
If most of the area surrounding the Westerville Municipal Building looks torn up, it's because two construction projects are happening at the same time in front and back of the building at 21 S. State St. -- from a local news website.
Your example is possibly definition 3 of to tear up from MacMillan:
[tear someone up] to make someone feel very unhappy or upset
Example usage:
He looks torn-up as he stares at her -- from a description of social distress in a book.
Without context it's tough to tell, but your sentence may also be referring to someone who has been beaten in a fight:
Cory won but he looks torn up -- the caption on a photo of a boxer who just won a fight.
By the way, while the Urban Dictionary can be a great place to learn slang, because of the way it is crowdsourced it can also be full of hyper-local or simply incorrect definitions, so I would not rely on it heavily.