Dead dog
Here’s what it means
A person regarded as utterly insignificant, powerless, or contemptible.
Why the Bible says it this way
The speaker uses exaggerated self-abasement or contempt, since even a living dog had low status and a dead one had less.
An idiom is a familiar phrase whose meaning comes from the whole expression, not from reading each word by itself.