BUG: Fix export .to_numpy() with nullable type
- [x] closes #40630
- [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

Under such a situation where a change causes cascading failed cases across multiple tests. Should I be modifying the other test cases? If not, what strategy should I adopt? > Under such a situation where a change causes cascading failed cases across multiple tests. Should I be modifying the other test cases?

There are a bunch of test failures, so I think the approach should be looked at more carefully first. Running tests locally should also always be the first step to catch test failures before using CI