A dying father took a road trip with his son in an attempt to rebuild his relationship before his death