If I'm staying over in the onsite accommodation, do I still need to pre-book my Ride Access Pass?

Yes, even with a hotel booking, Ride Access Pass users will still be required to pre-book their reservation to the attractions.