I have been continuing to test and in my main test environment where i have a 23H2 device and 24H2 device to test against, i applied the below setting (which i mentioned earlier in the post but never actually tested initially) onto the DC's at that site. This seems to have allowed 23H2 to update password correctly for the last 2 days.
The 24H2 device at my main test location continues to not update password but also not to lose trust relationship with the domain. However a fresh 24H2 device at a second location (Second location's DC does not have the below setting applied to it) is updating its password daily so i suspect the one not updating has a separate issue.