Use the standard PIP_CACHE_DIR for Python dependency caching template

What does this MR do?

Bundled Python dependency caching template misses the definition consistency between pip and GitLab CI caching. Also it comes to use the standard PIP_CACHE_DIR for Python dependency caching template (typically PIP_CACHE_DIR = XDG_CACHE_HOME + /pip).

What are the relevant issue numbers?

Closes #52408 (closed)

Relates to #50289 (closed) (!21902 (merged))

Does this MR meet the acceptance criteria?

• Changelog entry added, if necessary
• Documentation created/updated
• [n/a] Tests added for this feature/bug
• Conforms to the code review guidelines
• [n/a] Conforms to the merge request performance guidelines
• [n/a] Conforms to the style guides
• [n/a] Conforms to the database guides