Apology for the delay.
I have got the update that the connector code explicitly marks bunch of tables as “read-only” such as system tables. Updating data manually in these tables could cause runtime errors causing the issue therefor it is by design marking them read only.
For the other issue, they are checking the feasibility if they can remove the Organization field as required from the connectors in the future.