You sound like my DH and DD - they're just as appalled. I love it and it's full of lycopene - mmm... lycopene! (and yes, I spoon it right out of that little can).
But I last drank...
Strawberry Kefir! It's a probiotic yogurt drink w/o even a hint of tomato paste.