Thank you for your detailed explanation! I should have known better how the game already works regarding the river tile yields. Irrigation from Large rivers and Lakes is nice to have but probably not super important.That is already happening with a normal River and I feel that I should leave it like that.
The main difference with "isFreshWater()" is that it also considers adjacent Terrains "Lakes", "Ice Lakes" and "Large Rivers".
As others already suggested we may discuss the food yields in a dedicated thread.