The youngest son of the legendary singer and actor had a long connection to rock music. In later years, he had been performing a tribute show to his father