The pin fixity is about small movement, not gross movement, until we get to seismic detailing. At a footing, the notional fixity is pinned, but not the actual fixity. The use of isolated footings provides the degree of rotation needed to use pinned fixity.
The proposed detail is not useful. If you were going to detail the connection between the footing and column to allow rotation under large deformation of the superstructure, it would require significantly more complexity. Even with dowels only along the central axis of rotation, it would require either debonding of dowels (and potential displacement of the column) or crushing of the concrete, in order to activate the hinge/pin.
Designing with pinned fixity at a footing yields a stiffer and stronger structure (as previously mentioned) and any fixity provided by the foundation element will add to stability but is not be required. It is a mistake to think that an actual pinned condition is necessary. That said, if the footing is at one level and then a slab is installed higher up on the column, excessive fixity may well be a problem. You can end up with a stiff column that is not strong enough.