ci: fix failing Python 3.12 tests

[devin-ai-integration]

Fixing CI for PR #599 by:

• Re-locked the lock file
• Commented out Python 3.12 from the pytest matrix
• Added skip marker for source-pokeapi tests that fail with Python 3.12 due to the API blocking bots/CI runners

Requested by: Aaron ("AJ") Steers (aj@airbyte.io)
Link to Devin run: https://app.devin.ai/sessions/3c0f38bcc54447919e01bf2bead1f251

[devin-ai-integration]

🤖 Devin AI Engineer

Original prompt from Aaron:

@Devin - Can you help me get CI into a good place with this PyAirbyte PR: <https://github.com/airbytehq/PyAirbyte/pull/599>

You can start by updating the branch from main, then re-lock the lock file. Then, comment out Python 3.12 from the pytest matrix, with a note that certain tests don't work in 3.12, even though PyAirbyte itself does work on 3.12.

After that, make a list of all tests failing in CI. Then add a pytest 'skip' operation for any tests that fail in CI. I believe source-pokeapi is failing now due to the service being blocked for CI runners (basically CAPTCHA) so we will skip anything that tests source-pokeapi with a note that the pokeAPI interface is blocked for bots.

I'll be helping with this pull request! Here's what you should know:

✅ I will automatically:

• Address comments on this PR. Add "(aside)" to your comment to have me ignore it.
• Look at CI failures and help fix them

Note: I can only respond to comments from users who have write access to this repository.

⚙️ Control Options:

• Disable automatic comment and CI monitoring