Faithful tight-binding models and fragile topology of magic-angle bilayer graphene