BUG: Using agg with groupy, as_index=False still returning group variable as index
- [x] closes #25011 
- [x] tests added / passed
- [ x ] passes `git diff upstream/master -u -- "*.py" | flake8 --diff`
- [x] whatsnew entry

This is supposed to solve issue #25011