On some new devices (e.g. 4.x) this option might not be present and volumes of ringer, notification and system are always linked.
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.