Is Macafee protection necessary with Big Sur

No. Nor are any third-party antivirus/security apps.

No more effective than a screen door on a submarine, so no.

if you are worried about security, please read Effective defenses against malware and other threats - Apple Community. it's a long read but it's very worth your time to read every word.