Tilting cotorsion pairs over commutative rings