Meaning: I'd rather be dead or I feel terrible.
Origin: Comes from the John Wayne movie true grit. Some horses were going to be sold to somebody to be made into soap, instead the characters buy the horses and ride them until they die. Instead of being rode until they died, they probably would have rather been soap.
Becky: How's work going today?
Lee: I'd rather be soap...