A druid/barbarian in a game I'm on usually has it ready at least once a day ..I don't remember anyone ever preparing absorb elements even after playing with many different groups. So I'm with you, in my experience it's a niche spell that is rarely used.
...but it might be an item.