I’ve just tested the query you are using on multiple boards and multiple items with subitems within my account and the results seemed to have always match what I see within the UI. Have you been able to try the queries I have provided over email that query the sub-item board directly instead of querying the parent board’s values?
If anyone within the community has had a similar experience, I’d love to hear more about that as well!