CI: Update pipelines config to trigger on PRs
- [X] closes #32705


Thanks for this! Not sure what is up with the failure - just restarted let's see... hmm, is the 32-bit build borked? we can just merge this and followup if needed later. Yea I guess need a follow up to get rid of the 32 bit one though; looks to be failing @TomAugspurger marking for 1.0.3 if needed This is marked as still needs manual backport. looking at the code changes there is reference to master. What needs to be done here? Not sure, I guess if we want to run the CI on other branches, the name of the branch (`master` in the diff) should be updated for each branch.

For context, without these changes, pipelines wasn't running. > For context, without these changes, pipelines wasn't running.

the azure jobs are running on 1.0.x, its the code checks that are not running i've removed the needs manual backport, but will probably resurface after 1.1.0 is released. > i've removed the needs manual backport, but will probably resurface after 1.1.0 is released.

cc @TomAugspurger I think needs to be changed in master so that when the 1.1.x branch is created, backport PRs will be checked