DOC: point out that explicitly passing axis=None is deprecated for sum, prod, var, std, sem
- [x] closes #54547

pointed out in the documentation of the methods: `sum, prod, var, std, sem` that explicitly passing `axis=None` is deprecated.

Thanks @natmokval 