fix isin method for series
- [X] closes #43460 (Replace 43460 with the GitHub issue number)
- [X] [Tests added and passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#writing-tests) if fixing a bug or adding a new feature
- [X] All [code checks passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#pre-commit).
- [X] Added [type annotations](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#type-hints) to new arguments/methods/functions.
- [X] Added an entry in the latest `doc/source/whatsnew/vX.X.X.rst` file if fixing a bug or adding a new feature.

Thanks for the PR @nvanommeren and @sophievdberg! The CI caught some errors which I think you can solve locally if you run pre-commit. Let us know if you need help. Thanks @noatamir, fixed some small problems. There are still quite some tests failing in `pandas/tests/computation/test_eval.py::TestEval::test_simple_cmp_ops` - just to check: should we update these tests as well? Yeah `Series.isin(df)` should raise IMO Thx! @nvanommeren Could you update the tests? This pull request is stale because it has been open for thirty days with no activity. Please [update](https://pandas.pydata.org/pandas-docs/stable/development/contributing.html#updating-your-pull-request) and respond to this comment if you're still interested in working on this. Thanks for the pull request, but it appears to have gone stale. If interested in continuing, please merge in the main branch, address any review comments and/or failing tests, and we can reopen.