Report found ‘insufficient funding’ from the lottery’s money for good causes was being invested back in deprived communities, despite their high rates of play.