Does Skuid override Salesforce validation rules and error messages?

No. Instead, Salesforce validation rules and error messages will display in Skuid.