>What does manifest V3 add to privacy or security?

By definition, restricting the APIs extensions can use limits their power. Less powerful extensions can do fewer things, good or bad. Fewer bad things adds to privacy and security. At least that's what I understand.

Yes, I know ad blocking makes your browsing more private and secure, but that's another discussion.