Maybe one day some really gigantic-awful-horrible-monstrous-humungous climate related disaster will hit us. And that, at that moment, people will stop playing the boiling frog and will be forced to admit that climate change is real and we have to do something about that.
Unfortunately, plenty of gigantic-horrible-etc. disasters have already hit us, but the public doesn't seem to have taken notice. But never mind, we might be hit by the really big one. And, if it happens, do you think people will come to the scientists and tell them "we are so sorry, now we understand you were right all along"?
I have the impression that it will be rather something like what you see in the clip, below. It will be something like what the woman says, "God is going to destroy this Earth and there is nothing you silly scientists can do about that with all your scientific blah-blah."
And I have this terrible feeling that she may be right.