It's definitely worth going! May is a great time to visit the water parks, partly because they're so much fun and party because May can be pretty hot.
You'll find queues at the most popular slides can reach 15-20 minutes (Teamboat Springs comes to mind), but I think 10 minutes or so would be a good estimate on average wait time.