WIP: AthenaKernel: Prevent implicit StatusCode conversion in CHECK

Prevent the following code from compiling as that relies on an implicit conversion of the return value of myFunc into a StatusCode:

int myFunc();

CHECK(myFunc());

cc @akraszna who found this loophole in !33960 (comment 3560163). Let's see how much breaks due to this change...