Unless Larian actually adds an item that specifically buffs the cantrip, you’re probably not going to use it even into mid-game anyway.
Cantrips gain extra damage dice at higher levels. And the disadvantage on the creature's next attack remains useful for creatures that attack (as opposed to creatures that force saves, it's not as useful against them). it's still not the most damaging cantrip, but the rare damage type and debuff make it a useful one to have.