Biden’s emotional family members looked on as he praised Kamala Harris and warned that the nation is at an ‘inflection point’ heading into the 2024 election