It means you look extremely pale.
Or you look like someone so tired you are on the edge of suicide.
(for pale).On god you are such a fresh corpse, have you even seen the sun?
(for tired). Dude you look like a fresh corpse, you gotta have some sleep