Turtles can be great pets, but, indeed, red-eared sliders are mostly aquatic. They're smaller, more terrestrial, and can be taken out for short interactions. You can read more about them at the Tortoise Owner blog. They can make excellent companions for kids!