Colloquium: Quantum root-mean-square error and measurement uncertainty relations