Change the default of `check_freq` to `False` as it breaks existing code

[MaxWinterstein]

As already mentioned in #34050 the default of check_freq was set to True, which leads to broken code / tests.

I suggest to change it to False as it ensures existing code won't break.

k thanks. pls open an issue to change this to check_freq=False; I think this might break downstream, IIRC a comment by @jorisvandenbossche

Originally posted by @jreback in #34050 (comment)

[jreback]

-1 on changing this.

[TomAugspurger]

See #35571 (comment).

We would be happy to have an update to whatsnew/1.1.0.rst to reflect the (accidental) API change.