rowID is an implementation detail of SQLite. In my opinion, you should still make an Id column for rows that don't have a different way to be uniquely identified. If you don't, it's harder to decide you want to use a different database later. Or, put another way, the SQL you learn won't work quite right on any other database, and you'll have to re-learn a few things later.

If you dig in the documentation, you'll find that "PRIMARY KEY INTEGER" columns are an alias for rowId anyway, so it's not like it's wasting space.