Small business optimism is rising, and owners are feeling better about the economy, even as inflation continues to pose challenges, the survey found.