Web scraping using Google sheets

After trying different ways to scrape the given website using other ways in Google sheets and even in Google Apps Script, it seems that it is not possible to accomplish your goal by just utilizing Google sheets functions or the website that you are trying to use implements some type of anti-scraping mechanisms. With that, you will need to look for alternatives like using different tools see this or using alternative websites.

Following @Tedinoz comment, it is indeed that the website uses Javascript to render dynamic websites. We can confirm that by disabling JavaScript on the web browser, in my case, Google Chrome. See below

After disabling JavaScript

The image above suggests that the website uses JavaScript to render most of its data which are the data that you are interested in.

References:

Disable JavaScript