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

[stable-2.16] support pip-compile check mode and remove pip-compile workflows from stable branch #4815