"Shit" can be a crude way to refer to things or stuff. Therefore, you can say: "look at that red shit over there" to refer to something that is red in color that is unknown to you or that is a real mess and it's red.
"Look at that shit", this means look at that mess or something that is distasteful to the speaker. This is a very common, albeit crude way to talk.