If you need a kick up the back side at age 40 to "push" you into an aviation career, then perhaps you don't have the level of passion required. Flight training is not the most expensive way to have a midlife crisis, but it's darn close!
If this isn't a midlife crisis for you, then you've got a chance of succeeding. It will be tough, so be sure why you're really doing it before you jump in.