BUG: compute.use_numexpr option not respected
- [x] closes #32556
- [x] tests added / passed
- [x] Ensure all linting tests pass, see [here](https://pandas.pydata.org/pandas-docs/dev/development/contributing.html#code-standards) for how to run them
- [x] whatsnew entry

also look thru the referenced issue for any other things that we can test with this. it is quite trick to make sure this is working propertly. lgtm. over to you @MarcoGorelli  thanks @saehuihwang 