Can Someone Resign as a Baptismal Sponsor?

No, once a person has officially witnessed the baptism and stood as the sponsor at the baptism, he cannot undo that action. The person, obviously, can stop fulfilling the role after baptism, but he cannot undo what has already taken place.