Make link targets private, as expected, Fix tests

As we dont want target that depend on our target to also include the libraries, we will change the linking interface to private for now. See: https://leimao.github.io/blog/CMake-Public-Private-Interface/

I also added a small fixup for the tests now in the detection backend