Hi JohnnyBravo2020 🙂
Yes, the admin/owner can share games with additional profiles on the headset.
The secondary profile(your wife) must create her own Meta account.... if she not already have one.
This account must be added to one of the headsets... let's say the Quest 2.
On the Quest 2 app sharing must be enabled, on the Quest 3 it has to be disabled.
Your wife will now have access to your game library and can she play the games with her profile and can make her own game progress.
You also can play games together.
Disadvantage of app sharing..... only the main game can be shared but not the DLCs you might have for a game. ☹️
For example Beat Saber.... in multiplayer mode playing with you, she can play the DLCs that you own, if she plays in solo mode she won't have access to any music pack that you've bought.
Add additional Meta Horizon profiles to your Meta Quest
Turn on App Sharing on Meta Quest | Quest help | Meta Store