May be submit to workflow the workflow will have two steps- one to insert data in crm and other to insert in share point 

Make the submit button hiddenadd another button on the form and on its click event store the data in crm and on success trigger the click event of the hidden submit button which submits to share point 

You can open the xdp and save it as static pdf then it should work with Adobe sign 

When you say not compatible what errors are you getting?Save the file as static pdf and it will works with Adobe sign 

Correct using the style editor and the state of the component in the best option 

What is the use case for changing the color programmatically?

Try using the style layer and then select error state and style the text box accordingly  

Here is the article https://experienceleague.adobe.com/docs/experience-manager-learn/forms/zipping-form-attachments/introduction.html you will need to make changes to the code to rename the attachments as per your requirements 

You will have to use custom code in your workflow to do thatsearxh for emailing attachments in AEM forms

https://experienceleaguecommunities.adobe.com/t5/adobe-livecycle-questions/copy-data-from-one-table-cell-to-another-table-cell-problem/m-p/300931 was this the solution that worked for you