Significant means you have enough samples to talk about the correlation. In this case, you can significantly say that there is NO correlation between those two variables.

What you can do to the data depends on the kind of data, but I wouldn't recommend forcing any correlation.

It is so clear that one variable is highly correlated with the other variable when it's values between -100 & 100, more points are around zero!!. Regards.

According to the image you provided that is not true. It can also be seen in the fact that the peak in 0 in one variable does not correspond to a peak in the center of the other variable.

Thank you for your valuable insights, Jokin. I must admit that I hold a slightly differing perspective concerning your initial response. In my view, at the 5% significance level, there appears to be compelling evidence supporting the assertion of a statistically significant linear relationship or correlation between the Y and X variables. However, it is essential to acknowledge that the correlation coefficient value suggests a relatively weak association between the two.

Furthermore, there is an intricate aspect that perplexes me, and I am seeking clarification on its interpretation. Notably, a substantial portion of the X values clusters around zero, which understandably contributes to the weakest coefficient value. Should we disregard this concentration of values near zero, a more discernible and potentially moderate to high correlation between X and Y emerges.

Another crucial observation is derived from the density plot of Y, which indicates a significant concentration of values around 100. This further underscores the complexity of the relationship at hand.