How about being honest with him.
Tell him that he will probably never ever make it but leave the option that he can continue to fly as long and as often as he wants to... with a flight instructor next to him.
Than it's up to him if he wants to spend more money on it or not.
