Remove spurious MultiIndex creation in `_set_axis_name`
* Resovles #25370
* Introduced by #22969

- [x] closes #25370
- [x] passes `git diff upstream/master -u -- "*.py" | flake8 --diff`
- [ N/A ] whatsnew entry
