Whether a complex is high or low spin does not solely depend on the ligands attached. There are other factors such as the size of the metal, the charge on the metal, the coordination of ligands, and so on, that can determine whether a complex exhibits high or low spin in Crystal Field Theory.
In this case, while $\ce{H2O}$ is lower on the spectrochemical series, that doesn't imply that the complex should have a low splitting and thus be high spin.
For example, $\ce{[Co(H2O)6]^{2+}}$ tends to adopt a high spin configuration. In fact, $\ce{[Co(H2O)_{6-n}(NH3)_n]^2+}$; $n=0-6$ was shown to favour high-spin configurations through DFT calculations even though $\ce{NH3}$ is considered a stronger ligand than water [1].
Therefore, $\ce{[Co(H2O)6]^3+}$ being high spin and diamagnetic doesn't mean that the ligand $\ce{H2O}$ is a strong field ligand. It just implies that all factors considered, the complex is more stable in a low-spin configuration.
Sources:
[1] https://pubs.acs.org/doi/abs/10.1021/ic0257930