Cenote Hopping Excursion

I wanted to go on a Cenote hopping excursion but I will have my husband, almost 6 year old son, and 9 year old daughter with me. I know it's a lot of traveling and walking so not sure if the kids will think it's too much. Anyone go on this excursion with their younger kids and thought it was worth it? I really want to go, but it is an all day excursion.