Well... it's really hard to say. I think that any time you're really taking a lot of photos (I clocked just over 4,000 in a week last trip!), you're losing at least a little bit of the thrill of being there. I rode Haunted Mansion three times that trip, and easily had the best time when I put the camera down and sat back and enjoyed my all-time favorite ride without worrying about if I was going to get decent focus on floating Leota head, go to ISO 6400, shutter priority or aperture priority or shutter/aperture priority, 50mm or 31mm, etc, etc... and I love Illuminations but I was distracted by a camera issue (my homemade remote shutter release acting up - I fixed one end so it'll be solid
forever then the other end had the ground wire come loose!) and ended up not enjoying the show nearly as much as I should have.
The upside to all this is, of course, the pleasure of looking at your photos later, and hopefully if all goes well, you have some that you're proud of or that show your family having a great time or are special in some other way.
This is the balance you have to strike... and everyone is different and everyone's situation is different (depending on the tolerance of your companions.)
One thing that is really nice about a DSLR is that it can be ready almost instantly. I left mine on all the time with no lens cap (always a lens hood on), it would go to sleep after 3 minutes so it wouldn't drain the battery, and I was able to pick it up and fire off some shots almost instantly if I saw something that caught my eye.
Now, if you
do have time for a "photo day" or even a "photo evening", that is even better. That way you can concentrate on photography without the guilty feeling that maybe you're missing something by looking at things through a viewfinder. I did a photo evening one of the nights, starting a little before 9 at the Contemporary then to the Magic Kingdom until 2, and was able to get lots of night photos that I just wouldn't have been able to get easily with the whole family. I also stayed later at Epcot one night for similar reasons. If I had a whole day, I'd probably be trying some shots with my neutral density filter and a tripod during the day, or some other things that are not very family-friendly.
Another thing to remember is that this will probably not be your last trip to WDW.

You'll have more chances later to get a shot that you missed this trip. You'll also be able to learn from any problems you had this trip on how to improve for the next trip.
And if all else fails and the wife is pressuring you to put that **** camera
down right now, just remember that you can always find other people's photos and pass them off as your own - I understand that this technique works very well for Mark.
