If this has some effect, and it has as the price of Doge shows, this is going to be temporary. The market is bearish at the moment and Doge could not just rely on the words of Elon Musk for its rise. And this is not something new. So the effect will be of lesser degree than the first and probably second time Elon Musk showed support for Doge. And of course this is not Tesla cars that could be bought using Doge. This is just Tesla merch.
Nevertheless, this news pushed the price of Doge by 30% in just a few minutes. Traders who are closely following Elon Musk's tweet have already recorded their profits from this news. Well, those who see Elon Musk as a crypto icon will continue to hold this coin until it flies away by several hundred percent again.