In my experience, querying the DB to assert content is correct in the front-end is rarely done.
The main idea behind the E2E automation tests is to ensure the functionality of the web elements are working and present. Things like:
Links are clickable and navigate to the correct page
Forms can be filled out
User sign up, user login, user modification (...
I don't think querying the DB for verification is necessary. Since your app FE is connected to API, you just need to query through API to verify things. The data verification should be done through testing of the APIs themselves.