I make this comment from the perspective of someone who is analytical but who is not an expert in statistics. One of the reasons for doing a linear regression is to get an answer to the question as to whether the values of two variables, x and y, are independent of each other. Alternatively, the data set may contain evidence of some linkage between them. If the confidence interval of "r" CONTAINS zero, that suggests that x and y are unrelated and that the calculated regression equation is of no value. If the confidence interval on "r" DOES NOT CONTAIN zero, there is a reason to believe there is reason to suspect that the value of x is somehow linked to the value of y. In this case, if you are building a statistical or mathematical model that includes both x and y as variables, you might want to include something that represents this linkage...it might improve the predictiveness of the model.
As a caveat, because I am not a statistics expert, I could have this wrong.