You don’t have to have a car to get around Grand Cayman, but it might be beneficial for some people. If you’re sticking in one area of the island, then a car might not be worth the cost.
But if you plan on traveling around, then getting a rental car is smart. Public transportation on the island isn’t the best, and while there are buses and taxis, they tend to be unreliable.