No matter what time of year you do the Mexican Riviera, it will be cold the first night, and somewhat chilly that first sea day, so be prepared for that.
We've gone in May, June, September and December...and it's always the same.
Once you get down to Cabo, the weather should be nice and sunny. We had an unusually rainy day in December....most of the time, they'll have rain for a bit of the day (a lot like Florida) and then it clears, but this day it rained all day.
Instead of the beach, we grabbed a taxi and had it take us to the glass blowing factory and waited for us, then took us to Cabo Wabo. After that, we walked around town, even in the rain. We'd worn "water shoes" so we didn't care that our feet were getting wet, and had our hoods up. We still had a great day. We were there for two days in a row on that cruise, and the next day was nice and sunny. We did a whale tour and then snorkeling. The water was chilly at first, but then we got used to it, and the beach felt nice and warm.
But again, on the way back to LA, that last day at sea is chilly and the last night is pretty cold. Just make sure you have a sweater for the dining rooms, and a jacket or sweater for out on deck.