Since it's a Melta based weapon, other Avatars are indeed immune to it, but as said it is not a Psychic attack. It says so merely for fluff reasons and should be ignored. If someone protests it is a psychic attack and things like Psychic hoods can ignore it, just show them the codex entry. Apart from that one word, there is no reference to it being psychic at all.