A new US report measures how long $1M would last for retirees 65 and older state-by-state and it isn't great news. The main upshot is if you want to stretch your dollars you'll need to head down south.