Chitty Chitty Bang Bang was a children's book. A really, really good book that was made into one of the worst movies of all time.
It was not a Bond novel.
And at 58, Niven would have been considered too old too play Bond, especially for the movies you listed.