^Well, it’s probably a bad idea to take out large loans for it, but taking out a small or average amount of education debt (in the $25-30K range or lower) is probably okay. Even most art majors are able to find employment that allows them to repay that debt.
OP, there are ways to combine your love of art with an interest in science and engineering. They actually go quite nicely together.
-Graphic design/computer-generated art.
-Industrial design. RISD actually has a major in this, but so do many other engineering and sciences schools. Industrial design is basically designing products that are intended to be mass produced.
-UX design, known by a variety of other names. You can sometimes find this in computer science departments, often in programs called human-computer interaction. And some programs are popping up that focus on this exclusively, like Michigan State’s experience architecture program.
-Animation, as you mentioned, whether it’s for game design or children’s television shows or movies, or something else
-Medical illustration
Maybe look at a few high-quality art schools (like RISD and CalArts) but also look at some great universities that have traditional art programs and/or other departments that will allow you to employ art in another field.