r - Interpretation when converting correlation of continuous data

A popular textbook on meta-analysis (1) discusses how to convert a correlation, $r$, to Cohen's $d$ (i.e., the standardized mean difference): I became confused about how to interpret the resulting

Spearman's rank correlation coefficient - Wikipedia

Pearson Correlation Coefficient (r)

Plot Two Continuous Variables: Scatter Graph and Alternatives - Articles - STHDA

Pearson Correlation - SPSS Tutorials - LibGuides at Kent State University

Chapter 5 Correlation Making Sense of Data with R

Correlation in Excel: coefficient, matrix and graph

How can I understand a categorical by continuous interaction? (Stata 12)

Fixed- and Mixed-Effects Regression Models in R

Correlation plot with one categorical variable and rest continuous - Cross Validated