This is now solved. I did more tests in the process of trying to create a publicly accessible dataset, but in the meantime I've found the solution.

In the data blend, I was importing some extra dimensions in both GA4 and Google Search Console sources (E.g: Date or Query). This generated the discrepancy in the metrics I was seeing.

By only keeping the primary key (Landing Page) as imported dimension and the metrics I needed the numbers match