I am able to replicate your issue. Empty lists usually means that required permissions are missing. To get list items from SharePoint sites you need following permissions.
Please refer to this documentation.
After adding all the required permissions I am able to get desired result.
Result
Hope this helps,
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have further questions about this answer, please click "Comment".