How do I check if a lightswitch field is false?
You have to use 'not 1' instead of '0':

{% set resources = craft.entries.relatedTo({ targetElement: category }).order('title').archivedResource('not 1') %}