BUG: Ensure consistent kwarg only restriction on df.any and df.all
- [x] closes #57087 
- [x] [Tests added and passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#writing-tests) if fixing a bug or adding a new feature
- [x] All [code checks passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#pre-commit).
- [ ] Added [type annotations](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#type-hints) to new arguments/methods/functions.
- [ ] Added an entry in the latest `doc/source/whatsnew/vX.X.X.rst` file if fixing a bug or adding a new feature.

Oh, my bad, okay 👌
Gotta learn about deprecating > Gotta learn about deprecating

Luckily, it is quite simple:

1) you decorate the method with this:
`@deprecate_nonkeyword_arguments(version="3.0", allowed_args=["self"], name="all")`
where `name` is the name of the method.

2) Add a whatsnew entry

3) Ideally, have a test (not sure whether that is needed)

These deprecations apply to both DataFrame and Series for at least the following methods: any, all, min, max, mean, median, sum, prod, std, var, sem, skew, kurt.


I had [similar changes in this PR](https://github.com/pandas-dev/pandas/pull/56739/commits/9de4f705f4ea170ae5aca64fddc704ef51db4905#diff-421998af5fe0fbc54b35773ce9b6289cae3e8ae607f81783af04ebf1fbcaf077) but removed them from the PR to keep it easier to merge. Feel free to have a look at that PR to see how to adjust some of the tests (some of them will fail when you deprecate positional arguments).
 > Luckily, it is quite simple:

Thank you for explaining, this is super helpful! 👍 This pull request is stale because it has been open for thirty days with no activity. Please [update](https://pandas.pydata.org/pandas-docs/stable/development/contributing.html#updating-your-pull-request) and respond to this comment if you're still interested in working on this. Thanks for the pull request, but it appears to have gone stale. If interested in continuing, please merge in the main branch, address any review comments and/or failing tests, and we can reopen.