What happens if there are conflicting migrations on two "parallel" branches?
What happens in you bad luck situation when commits are pushed in rapid succession on the same branch?
As for running migrations on the same database from multiple branches, not a good idea. Probably best to decide on the branch that is the release branch (maybe main/master) and only deploy from that.