I think at least if it's not the currently active tab it will still go to sleep, so it's not like a random Autoplay video in a background tab will ruin your day. At least that's what it seems like with Firefox on Linux.