Retire redis-py entirely or upgrade redis-py to latest version

Currently most Redis client usage is migrated to valkey-glide, but the only remaining dependency is Redlock (distribute lock using Redis).

Let’s make it to use valkey-glide (retiring redis-py) or latest redis-py without connection pooling.

JIRA Issue: BA-2585