"RIP" is subjective. As an acronym it can mean Rest in Peace, Radiate in Purity, Rock In Power, etc. The "Rest in Peace" association lends an edgy, somber vibe fitting for rock, punk, gothic, or metal. However, some may find it macabre or insensitive.
Consider:
Research thoroughly before committing.