Cider can be either very mild or very strong. It can be sweet or dry. It can most definitely get you drunk. Any alcohol over the 0.05 “non alcoholic” beer can get you drunk in sufficient quantities.