Do you need more card ideas for the D&D Adventure System games?
I know there are some divine characters that are proficient with weapons is this card directed more to them?
This. Cards do what they say in Pathfinder, so barring a FAQ or Forum post saying otherwise, you have to apply the non-proficiency penalty.
Perhaps the "magical" appearance of a weapon and the D8 + Scenario (Adventure Deck?) number represents the deity's total assistance for wielding the sacred weapon. I'd imagine a non-martial character with no weapons and a foe immune to their items and spells would be pretty grateful for the miraculous appearance of a long sword; regardless of how well they wielded it since it's better than the basic STR check in most cases - perhaps in the situations where it's worse the character struck a really bad blow or the evil present was so strong the diety couldn't cut through the noise to provide the proper level of assistance.