This seems OK in my opinion. Twitter gives a useful error message to a situation which ought to be handled by the user. You wouldn't want to just truncate the title by an arbitrary number of characters; you'd end up with gibberish, misinformation, or obscenities (depending on your luck).
The user can trim this as appropriate, by:
- Converting "Stack Exchange" to "SE"
- Converting "Science Fiction and Fanasy" to "scifi"
- Removing "In production" from the title
- Removing your tracking reference
/3255 (though this might get stripped out by t.co; I don't use Twitter enough to know whether this is important.
Or, best yet, writing your own tweet! A stream of "My answer to Stack Exchange [sitename] Q: [title] [url] is more than a little inane. How about something like
Turns out the Ferengi "Divine Treasury" doesn't exist in this(?) life. Bummer! http://scifi.stackexchange.com/a/8365/3255
Real-world uses of Latinum in Star Trek: http://scifi.stackexchange.com/a/8365/3255
It seems that Latinum, unlike gold, isn't really useful: http://scifi.stackexchange.com/a/8365/3255
or something else a little more...human than the stock phrase.
Granted, "I quoted a list from MemoryAlpha" isn't an answer I would tweet. Preferably, you'd have answers with creative insight or that Used Science that seemed interesting. Summarize the answer in a hundred characters or give a teaser, and provide that link. Tweets like that seem far more interesting (again, I don't use Twitter much, so I wouldn't know) than bot-generated ones.