Superconducting charge qubits from a microscopic many-body perspective