Can a standard user sign up for a free trial and connect their Salesforce org?

No, standard users will not be able to sign up for a free trial and connect their SF org. Only users with admin rights can install and configure the SMS Magic Converse App and connect their Salesforce org to use all available features.