It's good if you're holed up in a defensive position. I like using it when defending the last point of Gorge. But rocket jumping is really hard with it so it is nowhere near as versatile as the other launchers.
It's also good if you're playing Doomsday and several enemies are riding the elevator. It's like Valve picked the perfect map to release with the Beggar's Bazooka.