At age 45 the answer would depend on personal circumstances and finances but since you're military and have to retire and change careers anyway, aviation is as good a choice as any right now.
But try to get a PPL before you retire, just to make sure you like it. At the very least solo.