I had kind of a stupid question: Do I need to use Kenney assets to make the logo and/or title screen image/background artwork? Or is it just the in-game assets that need to be Kenney assets?

Try and use the Kenney game assets, however you can include the logo of your studio and a logo for the game. Fonts and audio files can be sourced from anywhere, or custom made.