Is RoHS and EMC compliance enough for a 24V industrial sensor to carry CE Mark?
My understanding is that, LVD only cares about product safety, and wants to ensure that nobody gets hurt while device is in operation.


Pretty much, yes. It cares about electrical safety, such as preventing humans from direct contact with voltage sources, as well as suitability of materials in regards to fire hazards etc.

LVD does not care about functional safety, such as the application consequences if a switch isn't working correctly. Nor does it care about safety components. That's the Machinery directive. The EN 60947 standards are harmonized below LVD and Machinery directives both.

I would also imagine that shock/vibration requirements apply to the type of product you linked.


  Does a product operating below 75 Volts mean that it is intristically safe (per European Standards)?


Not at all, it simply means that the LVD directive does not apply. You still have various application-specific directives though, depending on the nature of the application. 

Also notable, if the product contains any form of radio, the RED directive kicks in with a weird rule that, in addition to radio compliance, also enforces LVD directive compliance regardless of supply voltage used.


  Is compliance to RoHS and EMC directives enough to mark my product with CE?


Yes, if it has &lt;50VAC or &lt;75VDC supply, no radio and no application-specific directives apply. 

For industrial electronics, the EMC directive will point at EN 61000-6-2.

In addition, you need to address the WEEE directive on an organization level, regarding recycling of the product. That part does not need to be in the CE declaration of conformity though.