After spending time trying to scrape the site using apps script and google sheets and also following discussions like this and Stackoverflow posts like this it is safe to say that Google Sheets’ IMPORTXML and even Google App Script’s UrlFetchApp does not have the capability to render dynamically rendered websites.
To accomplish the goal, you would need to use other tools like Selenium WebDriver that has the capability to wait for the site to load up completely and then scrape it.
You may also try submitting the idea of fetching dynamic websites using apps script as a feature request here
References: