DEPR: freq ''2BQ-SEP" for to_period should raise an error
- [x] closes #56899

corrected the definition to_period to raise an errror for `freq = '2BQ-SEP'` and add tests

No whatsnew note as this is only on main yet.
@MarcoGorelli, could you please take a look at this PR?