From a triumphant show of Charles I's collection at the Royal Academy to an Andreas Gursky retrospective at the revamped Hayward Gallery