The IACOB project. VII. The rotational properties of Galactic massive O-type stars revisited