it simply means, something sounds interesting and may cause fun. If you love films and someone tells you a film festival is going on nearby you can say, wow!! sounds like fun. hope this helps.

Someone may have described an activity (it could be an invitation or just a description of what they have done). If you say "it sounds like fun" it is something you would want to do. The activity would bring you joy. You may or may not do it.