What seadart said. Most surf boards (sup's included) have a certain range of wave size and shape that they work best on. That's why many prone surfers have a quiver of 3 or 4 different boards to choose from depending on the day's conditions. The kind of board you are talking about will surf but it'll have about as small a "window" of surf-able waves as any other kind of board. It'll work best in small, mushy, spilling waves. But you'll have a blast on those.
Free Standing Boat Racks
Recreational Kayak Paddle