The Pivotal Role of s‐, p‐, and f‐Block Metals in Water Electrolysis: Status Quo and Perspectives