Ground state solutions of non‐linear singular Schrödinger equations with lack of compactness