Most Americans say intelligent life exists outside Earth and don't see UFOs as a major security threat