Based on your requirement, the approach of PnP PowerShell alone for the actual content migration is not a suitable / recommended approach.
Migration Tools
- ShareGate - Best tool in the market
- Metalogix
- Avepoint
- SPMT (Microsoft Migration Manager)
these are the tools available in the market for the migration of contents from source to destination based on the pricing you can choose the relevant tool.
If this is SharePoint Online to SharePoint Online with strict requirements for version history, permissions, metadata, and reporting, evaluate a third-party migration tool which i recommended from the above list.
If the requirements are simpler and the source scenario is supported, SPMT or Migration Manager can work, but validate with a realistic pilot phase.
For e.g., If you select the Migration tool as Sharegate all the queries which you have ask that tool itself will taken care (throttling / Permission / Version history / metadata) so it depends on the product.
Similar query in the past
✅If this helped, please Accept as Solution to help others ❤️ A Like is appreciated 🏷️ Tag @MS.Ragavendar for follow-ups.