I had lookup column in other table frozen this way for a long time. The only way I got it to work is to select the queued cells right click and run those selected or click each cell to run. It's easier if you filter for queued rows only.
You can use Chatgpt to structure the data in a json array. Example
"teachers":[{"name": "title"}, {"name":"title"}]
Remember to use json for the output.
Then you can write to the rows in the other table