Yeah, it's a kid's song with a deep meaning:
The light-hearted meaning is that Uncle Walter is an eccentric, and his family accepts his whimsical behavior.
The darker meaning is that Uncle Walter goes out at night on a bender, getting drunk. He comes back drunk and disheveled the following day, so the parents tell the kids that Uncle Walter went Waltzing with Bears to explain his appearance benignly.