feat: run validation for PRs with main as a base
Created by: kshychko
This PR updates workflows to be triggered for PRs with main branch as a base instead of data-models-staging. It also adds an additional job to validate artefacts if the PR is a release one.