The zipped structure should look like this:

python/
  lib/
    python3.11/
      site-packages/
        pyodbc/
        pyodbc-5.2.0.dist-info/

Did you verify that the pyodbc library is available in the Layer by extracting the Layer zip file and checking the structure?