Kirk emphasizes that while SSDs offer improved performance over traditional hard disks, the real challenge lies in the bottleneck of transferring data to the CPU. He discusses the innovative approach of using RAM exclusively in a bank's system, which surprisingly increased reliability by eliminating mechanical disk failures. As memory and CPU bottlenecks persist, strategies like main memory computation become crucial for enhancing application performance.