Okay so it is quite complicated
So we prefer to derive the Work from the Recording Title, this is because if the work is in the title this is likely to be how you know the work, whereas the connected Works may look rather different, the obvious difference being that the title will probably be in users language whereas the connected Works will be in the composers language (although interestingly dont seem to have this problem for the most famous Russian Composers)
For example this is a Work by Bach with title 6 kleine Präludien: Präludium E-Dur, BWV 937
https://musicbrainz.org/work/671aeca6-05b4-3a40-823b-0d12b2a2a308
And listed below you can see how the title appears for various recordings of the work such as Prelude in E major, BWV 937 or Six Little Preludes
So, to reiterate we try to derive work from title, if we cannot we use MB Works. We know the MB Recording Work linked to the recording (the Movement) and we know its parents work (the Work) so we know a particular group of tracks are all part of the same work, if we cannot derive the same work from the title for all tracks in the group consistently we use the parent work of the MB Recording Work linked to the Recording.
Now in this case the titles actually show the overall work Messiah, HWV 56 rather than the three parts that make up the overall Work and so deriving work from title gives us Messiah, HWV 56.
But for tracks 1-19 we could not derive work from title for two tracks
- Messiah, HWV 56: I. Sinfony (Grave: Allegro Moderato)
- Messiah, HWV 56: IX. Air (Contralto) and Chorus: “O Thou That Tellest Good Tidings”
because they have a second colon, so cannot reliably work out work just by looking at this title, so because we cannot find a consistent work for all tracks on title we use the linked MB Recording Work parents work, and for the first nineteen tracks this is Messiah, HWV 56: Part I
We dont have the colon issue for the tracks making up Part II and Part III so we just use the work name derived from title which is Messiah, HWV 56
Possible Solutions
If we look at the MusicBrainz Work tab of the spreadsheet we can see that all tracks have the same value for MB Work, and the right part for the MB Work Level 1
So maybe your solution is use Scripter task to get works from there when not happy wih the one derived from title.
Possibly we could add option to always get Work from MB Work Level 1 Work but then we have the issue of not using Work names that match title.
Maybe better would just be to ensure consistency within release, so in this case since we we could only derive work from title from parts 2 and parts 3 I think we should probably use the MusicBrainz work method for all tracks?