Am I wrong for not supporting my boyfriend

My boyfriend has always wanted to write films. He was majoring in film writing in college before he dropped out because school got too expensive. He is still determined to do this but he's 32 now and honestly I wish he would just put this dream to rest. Don't get me wrong. He's a great writer and his movie idea aren't bad. He actually finished screenwriting a show pilot he's been working on for 4 years. So before we were even together and it's honestly really good but I was realistic with him. Where would he get the funding to even produce this show. I asked "What are you expecting? To get some deal with Netflix? You've wasting 4 years of your life on a tv show pilot that will never become a real show." He was convinced it would and he was so proud of it. I wasn't trying to be mean but someone needed to knock his ego down a beg and let him know how ridiculous it is. He has no funding, it's not like he has Netflix connections. I told him he should just cut his loss and post it on Wattpad and let a bunch of 15 year old wanna be writers read it and that can be his fame. He got pretty upset but I think I finally got through to him. I know a girlfriend is supposed to be supportive, but realistically this is stupid.