Advancing Neutral Atom Quantum Computing: Unleashing the Potential of Alkaline-Earth Atoms and Beyond