Since you already enabled "manage notification categories for each app" now go to Settings > apps > select app > notification categories > press on any of fallowing option like chats calls etc > sounds > select desired sound
Since you already enabled "manage notification categories for each app" now go to Settings > apps > select app > notification categories > press on any of fallowing option like chats calls etc > sounds > select desired sound