You want to use this api option in your series config: https://api.highcharts.com/highcharts/series.column.inactiveOtherPoints
As stated in the documentation, this option achieves exactly what you want: "Highlight only the hovered point and fade the remaining points."