U.S. drillers need oil prices to stay above $50 a barrel in order to make a meaningful return on capital, Moody's said.