Analyzing Character Representation in Media Content using Multimodal Foundation Model: Effectiveness and Trust