I think it is usually accompanied by an implication that your replacement may have fewer reservations than you do, constructing a moral dilemma.
It's like when a political figure resigns for ethical reasons. Does the message of the resignation really have more impact than having someone inside the organisation working for what they believe in, however futile it may be? There's never a shortage of sycophants.