A documentary film about the Girl Scouts, which was produced by the Duke and Duchess of Sussex’s company, earned less than £260,000 in its opening weekend