On some new devices with newer versions of Android OS (e.g. 4.x) the build in applications such as email, gmail or SMS doesn't use system settings.
Instead each of this application has its own e.g. vibration settings. So sadly enough, there is no way we can manage that from profiles.
This applies for SMS sounds and vibration as well because we can't affect settings of other applications. When you don't set ringtone for SMS in your SMS app then the ringtone set in SVC+ should work.