"Was the TSR2 program far enough down the road for it to have really fulfilled the status as 'Britain's Great Hope etc etc actually realistic"
No - still a lot of engine issues for a start. Reading about it 60 years on you get the impression that it became totemic - it was going to do EVERYTHING and was the last great hope of the old UK Aircraft industry. Cost control was even worse than it is today and the strategic mission was taken over by SSBN's. Some writers say it was a criminal conspiracy to scrap them. other that the Air Staff seem to have deliberately stuck their heads in the sand and ignored all the economic and political issues deliberately. Oddly the writers don't spilt along the usual lines - some who were pretty gung-ho about all thing aviation became "scrappers" and others, who had taken a cool view of British Aerospace became quite enthusiastic about the aircraft.