Should I Cancel on the Skunk Ape gig?

So here's the thing.  I was thinking of how short the role I'm playing is and now I'm questioning myself if it is worth driving for 4 hours, paying for a hotel and kissing some other guy for no pay and for such a tiny role.  But then again, that's all I got at the time.  It's bad for me to cancel at the last minute but I don't have money to be wasting.  I'm kind of stuck =(