To be fair, both of those are delicious. That said, I haven't had caviar itself (too expensive), but I've had plenty of other fish-egg products, and it's fantastic as a sushi topper or in a salad or something. I also love lobster, crab, and other "weird" foods from the bottom of the ocean.
My grandfather liked black caviar and had it sometimes (it's cheaper than you would think, or was in the 80s). I remember it being mostly just salty. I did not care for it.
If it's anything like other kinds of fish roe (I don't see any reason why it wouldn't), it's not something to eat on its own, but with something. It basically adds some fresh fishiness to whatever you're eating, for example mild pastas like alfredo or carbonara. I really like fish, so I find it adds some nice flavor to a wide variety of dishes.
Hmm, he was probably missing out if that's all he had it with. I'm sure it's fine, but there are so many other ways to enjoy fish roe than just with bread or crackers.
If you're ever up for trying it again and like fish, try adding a little to an otherwise mild dish. If you don't overdo it, you'll keep the mild flavors of the dish, but with a taste of the ocean as well. A little goes a long way, so don't go too crazy.
It's certainly common, I just think there are better ways to enjoy it, especially for people new to it. But eating it on bread or crackers is the goto, at least for caviar itself (less so for other types of fish roe).