No. No. Just no. Do not allow this. It’s not normal and it’s all kinds of really creepy.
I see nothing wrong with the Grampa falling asleep if he’s holding a child and they fall asleep. A kind of uninitiated nap. But to ask if he can nap with her because he wants to is just asking for trouble.