is your husband wanting you to come and bring the kids? otherwise, it doesn't make much sense. if he has strong feelings and needs you there for support or something, then i'd go (maybe the hotel will have a pool or something and you can make it fun for the kids) but otherwise, no. if he's gone all the time it can't be THAT big of a deal for him to be out of town for a few days. i really wouldn't even consider it unless your husband just really wants you guys to be with him.
i definitely would not take two small children to the actual funeral, especially if you were not very close to the family member. there's no need for that and they would not "get" it, just be a disruption. kind of rude imo. i don't think that people close to this person and truly upset at their passing would appreciate a mom bringing her two small children and using their loved one's funeral as a "teaching" moment. i do, however, think that bringing them for the family dinner (if there is one) would be wonderful, and i'm sure the family would love to see them.
a two year old, especially, will not "get" the solemnity of the situation or understand if you and dad are moping around all weekend. but yes, kids can find fun anywhere. we drove 1/2 way across the country with our 2 year old and we had a blast. (not true at all that no trip is fun with a 2 year old - it's all in how you approach it) so like i said, if you think dad will benefit from having the kids there for a little moral support (i know mine always makes everything right when i spend time with him) then maybe it's worth it.