While you might assume that the BLOG module is no longer included, what you'll find is that ALL the modules except for a couple are no longer installed by default. This is for performance reasons. The more modules you have installed, the more resources your website uses and that can degrade performance.
Those modules however are all still available, they just need to be installed before use. Go to the Host/Extensions page, from the actions menu choose the Install Available Extensions option, you'll find all the "core" modules there.
The blog module is actually getting ready for a new and much needed release.
DNN isn't trying to shirk away from Social Media aspects, I can assure you of that. The platform will continue to grow, from a business sense as you've seen, but in other ways as well. The new taxonomy features and folksonomy features coming in DNN 5.4 are intended for that social (crowd sourcing) aspect.
I think DNN is still a great platform to build a fantasy football website off of, or any other non-business type of site. All of my personal sites run on DNN, many of them having originally run on CommunityServer.