column profile: refactor out into type-specific column profiles

[bcolloran]

@hamilton do you recall this discussion or have any additional context or suggestions on this?

(discussed during SF workweek repo review)