Some locals see the River Adventure Ride at Galveston's Rainforest Cafe as a cheesy tourist trap, but a growing number of millennials and Gen Z fans love it.