In office hours @Darren explained the relationship between multiplayer mode and the occasional blurring of the workspace and display of a "Connecting...." message banner across the top of the screen.
I have noticed the following "side-effect" behavior when this occurs. As far as I can see, when the connection is restored everything is "just fine". However, any query with "Run this query on page load" turned on seems to be executed after the connection restoration.
As I understand it, the connection in question is used for state reconciliation by the multiplayer feature. If the state reconciliation process "works well" (and it seems to, AFAIK) there is no need to "restart" anything. Running the page load queries directly undermines the goal of "keeping state stable and in-sync" as state is probably, for most applications, blown away by running these page load queries.
I would encourage Retool to see if it is really necessary to run the page load queries after this reconnection process. While ensuring the integrity of the multiplayer IDE and source code state is definitely the highest priority, this behaviour, more or less, conflicts with that goal as any WIP debugging is blown away.