The SPO cmdlets require the SharePoint Admin role (or Global Admin). PnP cmdlets require permission based on the scope of the cmdlet; this could be as little as Read or Member access to a particular site. Some PnP cmdlets require the SPO Admin role, but those are the PnP tenant cmdlets.
You should use https://www.powershellgallery.com/packages/PnP.PowerShell as the other module you listed is no longer under development.