If a message shows as unsuccessful, then Twilio has received a delivery receipt indicating that the message was not delivered. This can happen for many reasons including carrier content filtering and the availability of the destination handset.
Example Unsuccesful SMS in Aesthetix CRM:
Your message may have been flagged as objectionable by the carrier. To protect their subscribers, many carriers have implemented content or spam filtering. Learn more about carrier filtering.