Better than that Fritz comes with an openings book which is derived from a database of 1,000,000 or more quality games. You can view the opening book in a separate pane which shows you move by move statistics for any given move in any opening, the statistics include the number of games a move was played in, % of games resulting in a win, average ELO of players etc.
Official Chessbase video on YouTube here skip through to the 12th minute if you want to jump straight into the openings book.
I think Fritz is amazing for reviewing and analyzing games but I think a chess tempo membership would be a better for overall trainer.
Just to answer your original question: yes, Fritz can show you the next best move(s).
I think it shows the best candidate moves (plural). Unsure if you can change that in settings to show more and the best line of continuation. The only time that I’ve seen CB or Fritz show comments like blunder or dubious or winning is when you run the analysis against a full game. Otherwise the bar graph showing a real time winning/losing side and by how much is all you can use to determine whether your current position is balanced or favoring white or black.
Fritz has several analysis modes. The 'infinite analysis' mode will check as many or as few lines as you want it is only limited by the number of legal moves in a given position. The Fritz interface changed after Fritz 15 so I'm not up to speed with the newer versions. The manuals are available from Chessbase online Fritz 17 manual here and other versions of Fritz and Chessbase here
For the AI piece, is there an option to have a game open where fritz shows me what the next best move technically is so I can add it to my opening repertoire?