Is Data Catalog right fit for us?

Yes, that's correct. But it's designed to provide data to people. It's not possible provide data from the Catalog to Google Data Studio. From what I understand you can feed Data Studio with CSV files stored in Google Drive. So you don't need the Catalog for that. Instead, you can use EasyMorph to generate a bunch of CSV files, upload them to Google Drive and point your Data Studio reports to the csv files on the Drive.

Alternatively, if the reports are not too complex, you can use the Catalog as a reporting solution. Soon, we will be adding Analysis View to the Dataset Viewer. Therefore, when you retrieve a dataset from the Catalog, it will come already with the Analysis View which may be sufficient for your reporting needs and eliminate the need for a separate reporting tool like Data Studio.