Your guess is right, it's indeed not true in general: Any choice of an $R$-module $X$ such that $X\otimes_R X=0$ and $f\
eq\text{id}: X\to X$ gives a counterexample, for example you could take $R := {\mathbb Z}$, $X := {\mathbb Q}/{\mathbb Z}$ and $f = 2\cdot \text{id}$.