Only if you actively enable airdrop and put your phone within a couple inches. You can’t leave airdrop on. It can’t happen accidentally.
If that is the case then it’s better but I’d still shut it off and err on the side of caution. The Apple demo video does not mention needing Air Drop enabled, only that both users need to be signed into iCloud: https://www.youtube.com/watch?v=aZL5D1k-4aI
That is not true, airdrop can stay on indefinitely when set to „contacts“ which is enough for NameDrop.
Can you then share it to everyone using namedrop that’s not in your contacts?
The whole point of NameDrop is to add a new contact. So by definition it literally won’t be usable for airdrop if airdrop is set to contacts only.