Chances of getting an upgrade by asking at checkin is probably zero.
If you have an economy cabin (inside) the only upgrade you are likely to get is maybe a higher floor. Cabin size and the view are the same. Any upgrade assigned by Carnival that you did not book is free of charge.
54 Carnival: Mardi Gras, Ecstasy X2, Fascination X6, Celebration, Elation X5, Glory X5, Fantasy X4, Valor, Holiday X3, Imagination, Liberty, Spirit X2, Freedom, Destiny X2, Splendor X2, Dream X2, Conquest, Legend X3, Victory, Sensation, Paradise, Inspiration, Magic X2, Triumph, Miracle, Breeze, Sunshine X2
6 Norwegian: Sky, Jewel, Dawn, Epic, Pearl, Breakaway
7 Windjammer: S/V Legacy X3, S/V Polynesia, S/V Caledonia, S/V Diamant, S/V Sagitta