Not specific to Carnival Pride, but we did a cruise on Carnival Sensation last February and it went to Nassau and Freeport.
I did snorkel in Nassau, it was a kind of windy and a little coll that day, but I survived. In Freeport, you can catch a $5pp shuttle to Our Lucaya and walk around, lay on the beach, shop, eat, etc. Some of the resorts have day passes available, but I didn't try those.
Anyway, for the pictures from Freeport and Nassau on that trip, see here:
Carnival Sensation, Feb 14-18, 2010, Main
In Nassau, you could also do a free, self-guided walking tour. Pictures of what that is like are here:
Free Nassau Walking Tour