Absolutely! Lots of things you can grow in a terrarium... but cactus and succulents, not so much (been there, tried that
) . Although, actually, mine was more of a closed environment; it could be that planting cactus/succulents in an open aquarium, using a suitable potting mix and being careful about not overwatering, would be completely successful. If those are the types of plants you would like to grow, I would give it a try...