I really want to get a dog, but I see how their passing affects people, and not sure I want to go through that. Is it worth it?

It is. Smaller dogs do tend to live longer lives, and as others have mentioned, rescue dogs can be especially rewarding. They just seem to know and can be especially loving.