I don't think it will be as large a failure as New Coke, if only because they haven't stopped producing their standard Coke. I don't expect it will take off, but will likely go the way of Lime flavored Coke. I don't remember seeing it recently, but I know I've seen it before.

Coffee and Coke mixed? Ick.

Hmm... maybe good over ice cream though. :)