Do you think the constant use of "great" sarcastically will end up with reversing its meaning so people think it just means "terrible"?

Words do that sometimes; it's interesting to see it happen.