This guideline doesn't seem applicable to the field I'm working with; the kinds of r values that are exciting change wildly depending on the type of thing you're researching!
Correct. This means that one variable (ADHD) effect explains ~4% of the variance in the other variable (interest in vore).
It is a small effect, but it's a good start and can lead to more questions!