I read that it took 16,000 88 flak shells to bring down one bomber. I infer the success of the flak was due simply to quantity.
I've also read numerous times that the searchlights would find and "pin" a bomber so that the crews could dial in the coordinates for firing. Wouldn't need that with radar guided guns.
I well know the death rate for B-17 crews - my father flew 32 missions in 1944 in one. The casualty rate was 80% (killed, wounded, POW). He told me that the way he dealt with it was simply accept that since he was going to die, he'd do the best job he could. I have the letter he wrote his father, dryly saying he'd completed his missions and would be coming home.
The Bismarck was well equipped with anti-aircraft batteries, which failed to stop the torpedo attack by slow-moving, obsolete biplanes. The Japanese navy didn't have much success with anti-aircraft batteries, either.
Regardless, the 88 was an excellent cannon.