chore: Update pnpm-lock.yaml and remove dotenv imports from backend files

Commit notes

This commit updates the lockfile version in pnpm-lock.yaml to 6.0 and modifies various package versions for better compatibility. Additionally, it removes unnecessary dotenv imports from the backend configuration and migration files, streamlining the codebase.