As I recall, there was some testing like that, but the question wasn’t quite so direct. Something like, “assume this is Coke. Would you buy it?”
Clearly a textbook marketing blunder in retrospect, but I think that the folks at Coke get skewered a little too much for a decision that made rational sense at the time. Coke invested a lot of money in testing the product and got good results. Weird thing happened when they went to market.