Thanks @johnrellis I've attached a dropbox link below. I have managed a work around which is to convert the files to JPEG, which retains the custom WB data, which gives me something to work with, however I'd prefer to be working with RAW files if I could.
Many thanks
Craig
Dropbox link
Your samples show what's going on in LR: To get a neutral color balance, LR / Camera Raw would have to set values for the Temp and or Tint sliders that exceeds the minimum / maximum values allowed by the Camera Raw engine:
johnrellis_0-1768058844066.png
Users with infrared cameras have faced the problem. Many of them solved the issue by making custom camera profiles:
https://community.adobe.com/t5/lightroom-classic-discussions/request-wider-white-balance-range-for-editing-photos-shot-on-infrared-converted-cameras/m-p/11760843
That post references a feature request to increase the range of the Temp and Tint sliders, but it appears that Adobe discarded that feature request when moving to the current forum platform. Here's another thread requesting an increase of the slider range for infrared photos:
https://community.adobe.com/t5/camera-raw-ideas/p-color-temperature-below-2000k/idi-p/12221221
Making a custom camera profile is way overkill for a one-off adjustment of a particular scene, as in your case.
Some have mentioned editing with Canon's DPP app or Capture One, which allows for a wider range.
You observed that "converting" the phtoos to JPEG produced visually pleasing result. Depending on the app you used for the conversion, it's simply using the full-resolution JPEG preview embedded in the raw file by the camera, which is what LR first displays when you import a photo before it applies its own rendering. Using the JPEGs may be the most expedient solution.