Apparently specifically because of the food issue they weren't generally worth the trouble. ACOUP has a good post about it [1]. TL/DR: For the amount of fodder and manpower you need for one elephant, you can have a lot of traditional horse calvary.

[1] https://acoup.blog/2019/08/02/collections-war-elephants-part...