Do I have to be a good swimmer?

No, but it certainly helps. You will be supported by the surfboard most of the time, but it is recommended not to rely on the surfboard for easy paddling of waves.