Thanks for the tip ixm.ibrahim (and the mini investigation), it works.
I didn’t really want to add a whole body of (hidden) ocean in my scene just to make the lake underwater transition work, but I’ll happily use this trick for now, until there is a more permanent fix.
Well done for finding the hack.