Beyond the Hype: The "Memory Wall," AI Accelerators, and the UK Visa Sponsor Jobs Powering the LLM Revolution