In that regard I don't think that he is any worse than a huge majority of bitcoin hodlers who only see it as a way to increase their fiat amount and bitcoin proved to be a very good for that.
The hypocrisy makes him worse. Those people who invest in bitcoin for profit aren't lying about it, in fact they call bitcoin an asset not a currency. Whereas Elon has pretended to care about the technology, ran a full node, used it as a currency in his business, etc. then suddenly went back on all that and showed his true face when he started pump and dumping an altcoin.
I don't think Musk stood to substantially profit off of any DOGE he held when compared to his total net worth. I think it is more likely that he was genuinely interested in the technology....that or he enjoyed joking around with the meme of DOGE.