Well, I don't know about it all being related to the speed sensor, but that could cause a few issues with maybe TCS. We recently had a thread on here (earlier this year) where we talked someone out of buying an '04 Quest...
topic616259.html
In that thread, there was mention of corrosion on the ECU. Maybe that is related?
We do have the factory service manual (FSM). This link is to a page with links for each chapter. Starting with the FWD chapter, you'll find the Foreward and Table of Contents. The EC chapter will have most engine related electrical stuff you'd be looking for (CEL). The transmission chapter and brakes chapter may have things related to the other lights like SLIP, ABS and TCS.
http://www.nicoclub.com/FSM/Quest/2004_Quest/