It's likely to be in the spool file: /var/mail/$USER or /var/spool/mail/$USER are the most common locations on Linux and BSD.
Other locations are possible – check if $MAIL is set – but by default, the system only informs you about /var(/spool)/mail.
Usually the spool file is in a very simple mbox format, so you can open it in a text editor or pager. For a slightly more convenient way, most distributions come with a program called mail (or Mail, mailx). You can try mutt or (re-)alpine; you can even configure it to be sent to an outside mailbox. (See "is this real mail?" below.)
- What does it contain?
- Who/What sent it?
Read it and find out :) Most often the messages contain output of cron jobs, or a system security report by logwatch, or similar junk.
Depends greatly on the contents of each message.
You should at least scan the subject headers – often people ignore the mail for months never realizing that their daily cron jobs fail.
Is this even actual "mail" in the same sense as email? Or is it just my system telling me something?
Yes, it's generated by your system telling you something. And yes, it's actual email, and can be handled as such.
You can (and often should) configure your mail software (the "MTA": postfix, exim4, sendmail, qmail) to forward the messages to your personal address – the exact instructions vary depending on which MTA (if any) you have installed, whether this is a personal computer or a server, whether you have your own domain or use a @gmail.com, and so on.
(Words of advice: Don't touch the Sendmail suite (which is not to be confused with the /usr/sbin/sendmail program). Other MTAs such as Postfix or Exim4 are just as powerful, and much less painful.)