On community wiki posts both the revision history link & community wiki links lead to the same page.
Shouldn't the username in the community wiki post point to the user profile page?
Community wiki link
This was always the way. It wasn't until recently that the last editor link was removed.
Community wiki posts are less about individual users and more about the collective work of all.
On non-CW posts, the last edited time links to the revision list. On the area noting the author (bottom right), it would link to the author.
Since a CW post is a group effort (ideals, man, they're glossy), it displays the author who contributed most overall (on a rough percentage) to the latest version of the post. It also links to the revision list to show you all of the authors/contributors to that post.
Again, on CW, it's about the Borg and not about the red shirt.