Nope. You have to specifically request that an account be "memorialized", otherwise it stays there just like they've not logged in. I had to do it with my wife's when she passed away.
And "memorialization" just makes it so that the account can't post, log in, etc - but other people can still post to that account's "wall" - "we miss you" messages, etc.