> so you have to declare the CTE as materialized to get this optimization

Not necessarily. You can get a materialized CTE if you request it regardless of its usage pattern, but you will also get one if the CTE is used more than once unless you suppress it.

That's not how I interpret the release notes, but I can see why they are being misunderstood like that (assuming I'm right in my interpretation).