CyanogenMod (called CM) is a custom ROM / aftermarket firmware.
Just as explained, CM is an aftermarket firmware, so it lives as your phone system.
Also, it isn't dangerous at all, really.
No, it won't destroy your phone if you use it right.
I have been told that what destroy your phone, is yourself. So, if you brick your phone it's because of you, not us or CM itself.