Will the migration to Acquia Search powered by SearchStax require my involvement?

Yes, the migration requires your involvement. You must install the required modules and re-index the data.