Biden's goal was to dissuade his party from dumping him. By sounding "feisty" and energetic (even if it was because of drugs), he probably succeeded in that goal. His target was the Democrat base, not the country as a whole.
He did offer a roadmap to the Democrats' strategy for the election--abortion, January 6, demonizing Trump and his supporters.
I don’t believe we’ve had an apolitical SOTU in decades. It would be virtually impossible to have an applause line for everyone and every faction.
I agree, his goal was to assure the Democratic base. I’ll add he was also performing for the undecideds.