Sort by one criteria and have another to fall back on
Managed to find the issue. The resources that didn't have a weight set were treated as having a lower weight than ones that did. I changed the weighting to sort by descending, which is the opposite of how weight should work, but seems to be the only solution.