He may be referring to the fact that many nocturnal animals wait for the cover of darkness to be able to get their food safely or in order to cloak themselves to approach their prey better. However, this seems to be a matter of personal opinion. He wants you to think that we are smarter because we have to hide and hunt in broad daylight. I haven't been able to support his theory as bats can be considered very intelligent - and they primarily hunt at night.
In fact, we also consider dogs - and their wolf counterparts - to be intelligent as well, and you typically only see wolves at night.
Also, studies are showing that humans who are "Night Owls" are smarter than people who are "Morning Larks" according to a study in Psychology.
If you're interested in different kinds of behaviours and how intelligent they are you can look at BBC Animal Adaptations, which has a really cool list of what abilities each animal has split into categories. Particularly, they have an "Animal Intelligence" section which goes into detail about particular behaviours humans consider to be signs of intelligence. Personally, I think their list is a little out of date - where it is missing a few animals - but by their standards, many of the nocturnal animals have not made it onto the list.
A reason that hearing could be a prerequisite for intelligence is that communication is considered to be a HUGE part of intelligent behaviour. Tool use could be a reason that sight is considered a prerequisite for being intelligent. Really, the five senses (sight, hearing, touch, taste and smell) allow us to really take in the world and adapt to it properly. Sight, hearing and smell typically allow us to be warned of dangers but the fact is that we have to be intelligent enough to know what to do with the information.
Summary: Intelligence can be measured in many different ways. Edward O. Wilson could have been looking at a number of different things when he came to his conclusion (where sight and sound were required for intelligent beings). The truth is that it is all speculative.
If you judge a fish's intelligence by its ability to climb a tree, it will grow up thinking that it's stupid.
Subsequently if you judge my intelligence by my ability to spell, I will also go on thinking I'm stupid ;)