“I drove a different Ferrari to the studio every day. David Gilmour and Nick Mason would wait outside to see which one”: How Sammy Hagar tried and failed to become a prog star after falling for Pink Floyd