Well, a materialized view is denormalized data. You distinguish it from the “underlying data model”, but you can do that in nosql as well. Also, materialized views still tend to be oriented to rectangular data, which isn’t always how you want to access data.

I agree with the general point that Postgres and other relational databases can do nosql things (and nosql databases can do relational things).