I came across the reddit post that Carowinds released a survey. It showed three different concepts which are: the log flume, rapids ride, and a water coaster. Either one of those would be a good fit to the park and it also fills the void in their lineup.
Direct Link to Embedded Media Source
Direct Link to Embedded Media Source