Move requirements to requirements.in and add precise versions in requirements*.txt

It is often considered a best practice to add exact version in requirements.txt to ease redeployability and debugging

Generated using pip-compile.

Versions I added are from a python3.11.3 venv.