Elon has used the greater fool theory for so long that they no longer exist on earth (at least fools with money who aren't also using the greater fool theory). It makes perfect sense he would focus on space because if he does find aliens it'll be an entirely new investor pool for him, and he desperately needs that now.