My understanding is that FDW's act as a proxy. I don't believe the tables are materialized.
Can you link me where it says otherwise? I don't see anything in the docs [1].
[1] https://www.postgresql.org/docs/current/postgres-fdw.html