Jester David
Hero
The character's spell save/ spell attack will be low. That's problematic. However, other stats like Dexterity (AC) or Intelligence (some skills) will be higher. More Con means more HP and greater survivability (and increased chance of making Concentration checks).
The PC will have to play differently than one with a high-Cha, not being the face of the party and instead buffing. In many ways, they're closer to being a buffing arcane trickster.
Lore bard gets more non-bard spells, so focusing on cantrips that work with melee attacks (or ranged attacks) works nicely. Building it as an archer can work very nicely, getting some ranger spells.
The PC will have to play differently than one with a high-Cha, not being the face of the party and instead buffing. In many ways, they're closer to being a buffing arcane trickster.
Lore bard gets more non-bard spells, so focusing on cantrips that work with melee attacks (or ranged attacks) works nicely. Building it as an archer can work very nicely, getting some ranger spells.