Yes, the red asterisk is helpful for scanning a page when looking for your own posts or comments (although it is also possible to use any browser's find-on-page

Yes, the red asterisk is helpful for scanning a page when looking for your own posts or comments (although it is also possible to use any browser's find-on-page search, usually implemented as CTRL-F on Windows browsers, to search for your own username).