If r between X and Y is 0.74, then r-squared is 55%.
According to many 'rules of thumb' and others, the effect size (in this case r) is considered 'moderate' or 'medium'.
As such, only 55% of the variance in Y can be explained by X. The remaining 45% remain unexplained.
Question 1: Given the above, how good is r when it can only explain 55% of the variance?
I know this depends on the context of the study but 45% of unexplained variance, by any measure, is huge. I am afraid this is the number (not 55%) that my (non-statistical) target audience will remember at the end of the day.
In other words, I may get a question such as "what is the point of the research when 45% of the result remain unexplained?"
Question 2: How should I answer this question?
Notwithstanding the above, I think 0.74 is a good and strong result!