Making it so you can manually resize "auto-size" columns is something we're planning to add.
For now, you can use the script here to toggle columns between autosize and normal.
It's originally from the video about column resizing modes, at 18m31s.