The IMAA's 2026 Indie Census finds cautious optimism - and a deepening tension at the heart of the AI opportunity.