fix(build): core doesn't not enable -Werror while it is supposed to

Description

Targets with an object library now properly activate warnings as errors when requested in sight_add_target().

Closes #787 (closed)

How to test it?

• Add some code that trigger warning somewhere in sight_core or sight_session
• Observe there is an error triggered when building