Quick fix based on https://github.com/pgadmin-org/pgadmin4/issues/9696#issuecom...

Click on the "Reset layout" button in the query tool (located in the top right corner), and it will move the "AI Assistant" tab to the right. Now, when you query a table, it will default to the Query tab as always.