The 40-year-old actor confessed that he had a rather X-rated ride on one of the family-friendly theme park's attractions in a recent podcast interview - and that wasn't all of it