It absolutely does literally foam. Maybe not in idle, just sitting there, but it does when driving under a load. That's when you get cavitation, and the fluid loses its ability to create pressure and to lubricate.