Spongebob probably won't get drunk for a looong while due to that car crash experience being the first time he's had any booze but he will be totally up for partying hard and adventuring with pirates! He can bring some edibles with him to compensate!