Image Sequence Rendered Purple Despite Being Within Image Sequence Range
Ok, so after a few days experimenting I can confirm this is a bug with version 2.83 and updating to 2.92 makes this blend file work as expected.