It wouldn't work on a CR 23 Kraken (MM 193) per se due to the size restriction, but maybe something like a Juvenile Kraken (GoS 239) from Ghosts of Saltmarsh would be susceptible to it.
The wording:
Adjust Density
At 2nd level, as an action, you can magically alter the weight of one object or creature you can see within 30 feet of you. The object or creature must be Large or smaller. The target's weight is halved or doubled for up to 1 minute or until your concentration ends (as if you were concentrating on a spell).
While the weight of a creature is halved by this effect, the creature's speed increases by 10 feet, it can jump twice as far as normal, and it has disadvantage on Strength checks and Strength saving throws. While the weight of a creature is doubled by this effect, the creature's speed is reduced by 10 feet, and it has advantage on Strength checks and Strength saving throws.
Upon reaching 10th level in this class, you can target an object or a creature that is Huge or smaller.
There's no save, it just halves or doubles the density of the kraken, so if it attacked your boat, you could double its density to make it sink to the bottom, or if you were fighting it underwater you could half it, to make it rise to the surface allowing you to recoup for 1 minute.
There's also no limit on its uses and its range is 30ft, so you could just hold an action in order to hit it before it got close enough.
Additionally, you could murder most NPC/humanoid characters by adjusting their density in water and having them sink like a rock to the bottom of an ocean, wherein they would have to swim hundreds if not thousands of feet straight up before running out of air (unlikely).
Overall, it feels like this Adjust Density ability is very strong in water and has an insane amount of potentially overlooked utility for a 2nd level ability, with no limits on uses, and no save.
Gargantuan monstrosity (titan)
which is a few sizes larger than the maximum size ofLarge
for Adjust Density. \$\endgroup\$