For the most parts, racoons are nocturnal. Yes, they do very rarely come out during the day, but most old folks can count on one had now many they have seen during the day in their entire lifetime. And, every racoon I have ever seen during the day (three, maybe four) were walking around in circles and falling over. It was not due to them eating fermented fruit, either. They were diseased and our county humane society took care of them in a humane fasion... they killed them as painlessly as possible in a gas chamber. If I would have had a firearm AND it was not in a populated area I would have ended their suffering myself.
About ten years ago, I lived in a pretty populated area. Our neighborhood bordered two of the largest roads in the area and the average lot size was 1/4 acre. We had street lights and the school bus practically emptied the entire bus on the corner one house away from us (lots and lots of kids). The first time we saw a racoon in our back yard during the middle of the day, I called animal control. They, in no uncertain terms, told me they would do nothing about a healthy looking racoon out during the day. They said it had become perfectly normal for racoons to be out during the day, primarily due to us - eliminating their natural habitat, etc. We had repeated racoon sightings while living there and one of them took up residence in a tree in our back yard and had a litter.
There's a big difference between this and the original post - the original poster's racoon was acting sick. But the 'any daytime racoon is sick' is no longer a strict rule everywhere, according to animal control in my neck of the woods.
Keith