We were there 2 weeks ago on our Conquest cruise. The $40 fee for the day included everything. We used the pools ( they have 4 or 5 of them ) the lazy river, the waterslides. We also snorkelled, used the paddleboats and the kayaks. All your drinks and food are also included. The cab ride is about 3 minutes from the port. We had an absolute blast that day. Jamaica can be a dangerous port if you are not careful, but this resort has a fully private beach with no one to pester you or try to sell you something. I would highly recommend it !!
I think we paid $4 per person for the cab. We didn't try to negotiate so I'm not sure about that. I didn't see any motorized watersport supplied by the resort, but there was jet ski rentals available close by.