[stable-2.17] support pip-compile check mode and remove pip-compile workflows from stable branch

[stable-2.17] support pip-compile check mode and remove pip-compile workflows from stable branch #4814