Exciting!
For anyone even remotely interested in the Space Shuttle this will be a 'must see'.
I was in NYC on the morning of 06 June 2012 when the Space Shuttle Enterprise came up the Hudson on a barge, to be lifted on to the Intrepid aircraft carrier - by the same crane which lifted UA1549 from the Hudson in 2009! Made our way down to the pier where hundreds of people had gathered to watch the spectacle. It took about 3 hours to attach the lifting frame and then lift the shuttle up on the flight deck of the Intrepid. Would love to go see it now.
The Endeavour in its new location will no doubt be spectacular! Just hope it will still be accessible - even in the vertical position.